Creating Table In Stored Procedure....

Database

Creating Table In Stored Procedure....

Hi All,

I need to create the volatile table in the stored procedure. I have written the stored procedure but it is giving following error

Stored Procedure :

Replace Procedure try( )
Begin
Create volatile Table try1( roll int) on commit preserve rows;
insert into try1 values(4);
End;

Error :
SPL5000:W(L5), E(3807):Object 'try1' does not exist.

If anyone knows the solution please tell me

Thanks in advance
3 REPLIES
rgs
N/A

Re: Creating Table In Stored Procedure....

It’s not an error code it is a warning ‘W’. It is just telling you that the object did not exist when you compiled the SP. It created the procedure. In your case since the table is being created in the SP the warning can be ignored. In other cases when the table reference is supposed to exist it might mean you did not spell the table name correctly. It is up to you to figure out whether it matters or not to your logic. Maybe a table is created by another procedure. It all depends on how your logic is designed to work.

Re: Creating Table In Stored Procedure....

Thanks a lot...

Re: Creating Table In Stored Procedure....

Thanks a lot.  This helped me as well as I thought i had that many errors.