-
I am trying to called a stored procedure in oracle from a unix script and pass it a variable. I am having a problem with the size of the variable. It is 16125 bytes. The max size on for SQL Plus command line length is 2500 bytes. Is there a way could go around SQL Plus and talk directly to my procedure??
-
Hi !
I know no way leading around sql-plus, but you could write the content of your variable into a temporary file, which your procedure could read (using the UTL_FILE package).
I didn't find any way of piping the data into oracle stored procedures.
Commit;
6502
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
|