3 Replies Latest reply: Feb 10, 2013 3:48 AM by Ahamed Rafeeque RSS

    execute procedure from forms

    Maahjoor
      Dear all,

      i want to execute a procedure from forms. my code is below for calling procedure, this code is working fine from the SQLPLUS, but not working from forms.
      forms_ddl('execute audit_sessions('||''''||'et20'||''''||',sysdate,'||''''||'HELP'||''''||')');
      my procedure is below
      CREATE OR REPLACE PROCEDURE audit_sessions(uname varchar2,logon_date date,APP_USER VARCHAR2) is
      begin
      insert into admin.session_audit values(uname,logon_date,APP_USER);
      commit;
      end;
      my table is below
      SQL> desc session_audit
       Name                    Null?    Type
       ----------------------- -------- ----------------
       ACTIVE_DIRECTORY_USER            VARCHAR2(30)
       LOGON_TIME              NOT NULL DATE
       APPLICATION_USER        NOT NULL VARCHAR2(30)
      kindly help. i am using oracle 10g database and forms version 9.0.4.0.19
      Regards.

      Edited by: Maahjoor on 09-Feb-2013 19:34

      Edited by: Maahjoor on 09-Feb-2013 19:35

      Edited by: Maahjoor on 09-Feb-2013 20:18