SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Inserting into a table from a stored procedure not working

723460Sep 22 2009 — edited Sep 22 2009

Hi all

I am running a simple insert statement from my SQL Developer command line - this is working and the row is being inserted into the database. However when I try and load a stored procedure with the same input parameters it fails and says there is not enough values...

Please could someone explain this as inserting from the command line with the parameters I pass seems to work fine.

Im guessing its something to do with the table having more columns that I am inserting - BUT as I am doing exactly the same thing as the insert statement on the command line I thought this would work ok?

Thanks for any infotmation

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 20 2009

Added on Sep 22 2009

14 comments

3,673 views