DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: calling stored procedures from forms6i

  1. #1
    Join Date
    Aug 2000
    Posts
    30
    Hi,

    can anyone help me in this.

    dev 6i

    I have a table which contains the name of my stored procedures.

    In the form during runtime i need to call one of stored procedure and i need to pass the values for the parameters.
    (so dynamically i am identifying the name of the procedure)

    select procedure_name into v1 from table_name where some condition;

    v1(p1,p2); -- calling the procedure

    Now i am getting invalid procedure during compilation.

    how to dynamically call procedure in forms.

    thanks in advance.

    regards,
    jee





  2. #2
    Join Date
    Jul 2000
    Posts
    296
    You have to use Dynamic SQL

    In 8i:

    select procedure_name into v1 from table_name where some condition;

    execute immediate 'begin '||v1||'(p1,p2); end;'

    In Oracle <8i use 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