GitHub

Include the ability to handle PL/SQL exception variables in the %throws annotation

Hi @markhawker76 Would you be so kind and provide and sample example of the test you want to do ? I'm not sure I understand the problem. The snippet above I believe should work in our testing ...
GitHub

Large UDT causes ORA-06502: PL/SQL: numeric or value error: raw variable length too long

NuGet Package: Oracle.ManagedDataAccess 21.4.0 Database version: Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Hello, we have a stored procedure in our database which has a ...
Ars Technica

Oracle PL/SQL question about global variables

What are the advantages/disadvantages of using global variables in PL/SQL packages? I have created tons of packages and stored procedures, but have never used global variables.<BR><BR>Any insight or ...
ZDNet

Simulate variable arguments in PL/SQL

If you know lots of programming languages, then you're already accustomed to the ability to declare and use functions with a variable number of arguments, where the number and type of arguments aren't ...
ZDNet

Store SQL*Plus variables

Oracle SQL*Plus has a very useful subparameter to the column parameter called NEW_VALUE. The NEW_VALUE directive allows you to store data retrieved from an Oracle table as a variable inside the ...