SOLVED!
the error was not in the stored procedure. It was how i was initilaizing the out parameters in the SQL+ worksheet command.
Jerico1313
Last Activity: May 14 '09, 09:46 PM
Joined: May 14 '09
Location: Jefferson City, Missouri USA
-
Returning an Oracle generated GUID through an out parameter
I am returning the following error when i try to pass an oracle generated GUID through an out parameter. Here is the following error message from SQL+ worksheet:
BEGIN Project.spm_Dat aInsertTest ( ' ', :out_PPLorgGUID , :out_SubNo); END;
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1
Below is the Test Stored Procedure...
No activity results to display
Leave a comment: