Go Around SQL Plus w/Unix
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Go Around SQL Plus w/Unix

  1. #1
    Join Date
    Jan 2001
    Posts
    515
    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??

  2. #2
    Join Date
    Mar 2001
    Location
    Cologne, Germany
    Posts
    24
    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
  •  


Click Here to Expand Forum to Full Width