I am unsure what your post meant. Are you verifying that the problem is because the v_acct_id has a conversion function, and v_acct_btn has a character function? Can you direct me to some documentation, or provide an explanation?
Thanks....
User Profile
Collapse
-
I am absolutely sure that the acct_btn is never returned NULL. I have tested this procedure for over 1.5 million executions consecutively without ever returning a NULL. Moreover, there are no acct_btn with the value of NULL on the originating table....Leave a comment:
-
I will do so.
The exact problem is that rows get inserted with a valid acct_id, but an acct_btn with NULL values when an Exception occurs.
Here is one error that was thrown. I am not worried about the exact error. I know what is causing it. I am questioning why rows still get inserted, but with an acct_btn that is nulls and the acct_id is not nulls. acct_btn is not nulls coming from the stored procedure (btn_sp).
...Leave a comment:
-
null data from bind variable on table insert
I have a PL/SQL script where I load data from a stored procedure into bind variables. Then, I insert that data from the bind variables into an Oracle table with a simple insert statement.
The execution of the stored procedure and the insert are in a FOR-LOOP.
[code=oracle]
insert into ccd_t
(acct_id,
acct_seq_no,
acct_btn)
values
(to_number(v_ac ct_id),
to_number(v_acc t_seq_no),...
No activity results to display
Show More
Leave a comment: