SQL*PLUS Question...

From: <satar_at_my-dejanews.com>
Date: Fri, 06 Nov 1998 17:08:35 GMT
Message-ID: <71vaek$b57$1@nnrp1.dejanews.com>

Hi
Our development team and I can't make this stored procedure to EXECUTE in SQL*PLUS. I simplified this stored procedure, and I was able to EXECUTE it in SVRMGRL and SQL WORKSHEET:

create or replace
procedure sp1 (a1 varchar2,a4 varchar2) as a2 varchar2(255); a3 varchar2(255); begin a2 := substr(a1,1,255); a3 := substr(a1,256); dbms_output.put_line(a2); dbms_output.put_line(a3); end; /

SQL*Plus: Release 3.3.2.0.2
SQL> ed
Wrote file afiedt.buf
1* execute sp1 ('hfsk...some 200 characters..jhgjg' , 'fhgfhf...hkhkj') SQL> /
execute sp1 ('hfskdhgkkjhfdfkshkfhshjfsdjfkhs *
ERROR at line 1:
ORA-00900: invalid SQL statement

I believe it's something simple in SQL*PLUS to allow for 300 characters or more to be inserted into a comments field. Something like a '/' or something like that.

Thanks in Advance...
Satar
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 06 1998 - 11:08:35 CST