This discussion is archived
3 Replies Latest reply: Feb 10, 2013 1:48 AM by AhamedRafeeque RSS

execute procedure from forms

Maahjoor Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points