Creating Table In Stored Procedure....

Database
Enthusiast

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
Enthusiast

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.
Enthusiast

Re: Creating Table In Stored Procedure....

Thanks a lot...
Enthusiast

Re: Creating Table In Stored Procedure....

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