Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    34

    Unanswered: interacting with PL/SQL

    Hi friends,
    is it possible to interact with PL/SQL from cmd line?

    In sqlplus you can do it with "accept".

    Thank you for help.

    Pappagone

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: interacting with PL/SQL

    Originally posted by pappagone1
    Hi friends,
    is it possible to interact with PL/SQL from cmd line?

    In sqlplus you can do it with "accept".

    Thank you for help.

    Pappagone
    Not in SQL Plus, no. In Forms you can of course. The difference is that in Forms some of the PL/SQL actually runs on the client (or application server) and so can communicate directly with the user. In SQL Plus the PL/SQL is sent to the database server to be run, and the database server cannot communicate directly with the user.

  3. #3
    Join Date
    Jan 2003
    Posts
    34
    Thank you ,Tony

  4. #4
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Thumbs up

    You can create your PL/SQL code as stored procedure. eg

    CREATE OR REPLACE PROCEDURE test (p_par1 varchar2, p_par2 date)
    ...
    ...

    Then call it from the SQL as

    SQL> exec test(&1, &2)

    It will prompt you to enter the &1 and &2 values, which is kind of user interaction. If that's what you mean. However to use this inside the PL/SQL code itself - not possible.


    Hope that helps,

    clio_usa - OCP - DBA

    dbaclick.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •