OraFAQ Forum: Server Administration » PL\SQL: Procedure can't be created through SQL*PLUS 'cause it's too long

Home » RDBMS Server » Server Administration » PL\SQL: Procedure can't be created through SQL*PLUS 'cause it's too long

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PL\SQL: Procedure can't be created through SQL*PLUS 'cause it's too long [message #369794]

Thu, 12 October 2000 20:09

bill
Messages: 75
Registered: November 1999

Member

Hi,
I create procedures through SQL*PLUS. However,if my procdure is too long,it will be trimmed and an error will be shown. I suspect that my SQL*PLUS configuration is improper. Please help! Thanks in advance.

Report message to a moderator

Re: PL\SQL: Procedure can't be created through SQL*PLUS 'cause it's too long [message #369795 is a reply to message #369794]

Thu, 12 October 2000 22:47

Aditya Deshpande
Messages: 3
Registered: October 2000

Junior Member

I faced the same problem. What you could be doing wrong is doing a ctrl-c ctrl-v kind of a thing. that does give a probelm. Instead of that write the procedure in a file xyz.sql and then do
SQL>@"d:\myprocs\xyz"

Works

Regards
Aditya

Report message to a moderator

Re: PL\SQL: use TOAD... [message #369826 is a reply to message #369795]

Wed, 18 October 2000 21:02

helper
Messages: 2
Registered: October 2000

Junior Member

Download TOAD and code the easy way.

Report message to a moderator

Previous Topic:	trigger trouble
Next Topic:	alternate SQL without Exists clause

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 14:14:31 CST 2025