insert/update/delete/lock procedures
Bai, October 30, 2001 - 10:49 am UTC
Hi Tom,
is there any examples about insert/update/delete/lock procedures, if we don't let them to be empty?
Client side
Famy, February 24, 2003 - 2:14 pm UTC
Instead of creating the package in the database, can I create it at the client i.e. as a forms package and base my block on it.
I tried to do that , and I'm getting the error that 'forms is unable to query'
February 24, 2003 - 2:25 pm UTC
the ref cursor needs to come FROM the database. it isn't a client side thing.
How to implement this?
A reader, June 11, 2006 - 1:22 am UTC
Hello,
How can I implement a package like this in forms? I mean how can I pass paramenter value to this package at runtime?
create or replace package demo_pkg
as
type refcur is ref cursor return emp%rowtype;
procedure get_emp_data( p_empno in emp.empno%type, p_cursor in out refcur );
end;
/
create or replace package body demo_pkg
as
procedure get_emp_data( p_empno in emp.empno%type, p_cursor in out refcur )
is
begin
open p_cursor for select * from emp where empno = p_empno;
end;
end;
/
June 11, 2006 - 11:54 am UTC
I haven't touched forms since March 1995.
You would be best served by using the forums on otn.oracle.com to ask about forms related questions.
But that package would compile into the database just fine.