|
-
Possibly (wild guess) you are running into line length limitations within SQL*Plus. As a workaround you could try breaking the line into shorter ones, e.g:
EXEC blah(:blah, :blah -
, blah, :blah -
, blah :blah );
or replacing the SQL*Plus "EXECUTE" shortcut with the full PL/SQL "BEGIN ... END;" block syntax. Or of course reducing the number of parameters. Do you really need 168 of them?
Making procedure parameters into global variables sounds like a bit of a hack to me.
Last edited by WilliamR; 01-26-2006 at 08:07 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote