Home » RDBMS Server » Server Administration » PL\SQL: Procedure can't be created through SQL*PLUS 'cause it's too long
PL\SQL: Procedure can't be created through SQL*PLUS 'cause it's too long [message #369794] Thu, 12 October 2000 20:09 Go to next message
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.
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 Go to previous messageGo to next message
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
Re: PL\SQL: use TOAD... [message #369826 is a reply to message #369795] Wed, 18 October 2000 21:02 Go to previous message
helper
Messages: 2
Registered: October 2000
Junior Member
Download TOAD and code the easy way.
Previous Topic: trigger trouble
Next Topic: alternate SQL without Exists clause
Goto Forum:
  


Current Time: Fri Mar 29 04:25:22 CDT 2024