|
-
What is the output from the dbms_output.put_line lines of code in the unnamed block and in the function?
In the unnamed block, this is line 6:
price_event_pkg.pos_items_stage(1, 100, sysdate, pos_mods_rowid);
pos_mods_rowid may be coming back from procedure price_event_pkg.pos_items_stage with only one value - the maximum rowid value.
After the line above, add the following lines:
dbms_output.put_line('unnamed block count' || pos_mods_rowid.COUNT);
dbms_output.put_line('unnamed block first' || pos_mods_rowid.FIRST);
dbms_output.put_line('unnamed block last' || pos_mods_rowid.LAST);
What output does this give?
As far as your function, for debugging, after line 7 (the FOR indx . . .line) add:
dbms_output.put_line('function count' || pos_mods_rowid.COUNT);
dbms_output.put_line('function first' || pos_mods_rowid.FIRST);
dbms_output.put_line('function last' || pos_mods_rowid.LAST);
What output does this give?
In the function, this is line 9:
dbms_output.put_line(pos_mods_rowid(indx)));
There are two left (open) parenthesis and three right (close) parentheses. Should one of the right (close) parentheses be deleted?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|