User Profile

Collapse

Profile Sidebar

Collapse
pretzla
pretzla
Last Activity: Feb 7 '08, 02:22 PM
Joined: Jan 3 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • 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....
    See more | Go to post

    Leave a comment:


  • 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....
    See more | Go to post

    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).
    ...
    See more | Go to post

    Leave a comment:


  • pretzla
    started a topic null data from bind variable on table insert

    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),...
    See more | Go to post
No activity results to display
Show More
Working...