How do I make this work in SQL*PLUS?

From: <satar_at_my-dejanews.com>
Date: Thu, 05 Nov 1998 18:06:13 GMT
Message-ID: <71spel$rgi$1@nnrp1.dejanews.com>

Hi Guys...my turn to ask a question: Our development team 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 Thu Nov 05 1998 - 12:06:13 CST