Posted on 2000-03-29
When trying to execute a procedure in SQLPLUS I got the following error
SP2-0223 : NO LINES IN SQL BUFFER.
I am running Oracle 8i on Solaris. Previously I was able to execute it properly but all of a sudden this error started coming up. The procedure is:
'CREATE SNAPSHOT SCM.SCM_MATL_DESP_HEADER REFRESH FAST WITH PRIMARY KEY FOR UPDATE AS SELECT * FROM SCM.SCM_MATL_DESP_HEADER@NEW1.TRM',
what is the reason for it ? I am unable to find any help for SP2-0223 error message.