| its possible to call?????????????? [message #408536] |
Tue, 16 June 2009 10:46  |
owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT
|
Senior Member |
|
|
hi all
its possible to call oracle database 10g procedure or function in forms 6i for example if i will make this statement as procedure or function can i call call this in forms 6i
DECLARE
l_empno EMP.empno%TYPE;
l_ename EMP.ename%TYPE;
par_rc sys_REFCURSOR;
BEGIN
OPEN par_rc FOR
SELECT *
FROM (SELECT empno, ename FROM EMP
ORDER BY dbms_random.value)
WHERE ROWNUM < 10;
FETCH par_rc INTO l_empno, l_ename;
WHILE par_rc%FOUND LOOP
FETCH par_rc INTO l_empno, l_ename;
-- your code should go here; I'm simply writing it to the screen
dbms_output.put_line(l_empno ||' - ' || l_ename);
END LOOP;
END;
thanks and looking for answer
baba
|
|
|
|
|
|
|
|
| Re: its possible to call?????????????? [message #410284 is a reply to message #410134] |
Fri, 26 June 2009 00:13  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
I assume that this is the first form that you have ever written.
Consider using a Data Block based on a Procedure.
Search this forum or google or the reference manual for 'Query Data Source Type procedure'.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
