Please Help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Please Help

  1. #1
    Join Date
    Feb 2001
    Posts
    100
    Hi all,

    How to call or execute a script(containing only SQL statements) from a PL/SQL block.

    Thanks in advance.


  2. #2
    Join Date
    Oct 2000
    Posts
    90
    As far as I know, you can't call scripts in PL/SQL. You could put your scripts as database procedures and then you could call them.


  3. #3
    Join Date
    Mar 2001
    Posts
    17
    I think your problem could solve using external libraries


  4. #4
    Join Date
    Feb 2001
    Posts
    389
    why call external scripts, put the sql query/or create corresponding procedure and call from inside dbms_sql.

  5. #5
    Join Date
    Mar 2001
    Posts
    17
    gpsingh,

    You are right but Hakimca is asking to call script file.
    You can't execute script file thru dbms_sql package



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