The answers have mentioned both, $$PLSQL_LINE & DBMS_UTILITY.FORMAT_ERROR_BACKTRACE. But I would like to add a bit about the difference between them: Predefined Inquiry Directives $$PLSQL_LINE & $$PLSQL_UNIT PLSQL_LINE predefined inquiry directive is a PLS_INTEGER literal value indicating the line number reference to $$PLSQL_LINE in the current program unit. From its definition, PLSQL_LINE is not suitable … Read more
This should give you all your parts: int partitionSize = 1000; List<List<Integer>> partitions = new LinkedList<List<Integer>>(); for (int i = 0; i < originalList.size(); i += partitionSize) { partitions.add(originalList.subList(i, Math.min(i + partitionSize, originalList.size()))); }
SQL Fiddle Here is a trivial example of use: http://sqlfiddle.com/#!4/8cf15/5
A SELECT INTO statement will throw an error if it returns anything other than 1 row. If it returns 0 rows, you’ll get a no_data_found exception. If it returns more than 1 row, you’ll get a too_many_rows exception. Unless you know that there will always be exactly 1 employee with a salary greater than 3000, … Read more
p_temp_foo is an IN parameter. By nature, these are read only. You could define it as an IN OUT parameter, or an OUT parameter. For more info see here: http://plsql-tutorial.com/plsql-passing-parameters-procedure-function.htm
You could do this, though probably not as slick as you’d like: declare type nt_type is table of number; nt nt_type := nt_type (1, 3, 5); begin for i in 1..nt.count loop dbms_output.put_line(nt(i)); end loop; end; If you create a type in the database: create type number_table is table of number; then you can do … Read more
Default values are only used if the arguments are not specified. In your case you did specify the arguments – both were supplied, with a value of NULL. (Yes, in this case NULL is considered a real value :-). Try: EXEC TEST() Share and enjoy. Addendum: The default values for procedure parameters are certainly buried … Read more
When creating the TABLE under B2BOWNER, be sure to prefix the PL/SQL function with the Schema name; i.e. B2BOWNER.F_SSC_Page_Map_Insert. I did not realize this until the DBAs pointed it out. I could have created the table under my root USER/SCHEMA and the PL/SQL function would have worked fine.
Historical reasons. They used to be different before 10g: On 8i and 9i, PLS_INTEGER was noticeably faster than BINARY_INTEGER. When it comes to declaring and manipulating integers, Oracle offers lots of options, including: INTEGER – defined in the STANDARD package as a subtype of NUMBER, this datatype is implemented in a completely platform-independent fashion, which … Read more
Use the command: SET FEEDBACK OFF before running the procedure. And afterwards you can turn it back on again: SET FEEDBACK ON