Home » SQL & PL/SQL » SQL & PL/SQL » passing record as a parameter to excute function
passing record as a parameter to excute function [message #36990] Wed, 09 January 2002 07:35 Go to next message
epro
Messages: 11
Registered: January 2002
Junior Member
how do I pass record from a table as a param to run and test the function. appreciate help.
Thanks

Report message to a moderator

Re: passing record as a parameter to excute function [message #36993 is a reply to message #36990] Wed, 09 January 2002 10:45 Go to previous message
Srinivas Konda
Messages: 29
Registered: October 2001
Junior Member
Hope this helps.

decalare
v_x varchar2(100);
v1 number := 10;
v2 varchar2 := 'SALES';
v3 varchar3 := 'DALLAS';
dept_rec dept%rowtype;
begin
dept_rec.DEPTNO := V1;
dept_rec.DNAME := V2;
dept_rec.LOC := V3;
v_x := xx_fun(DEPT_rEC);
DBMS_OUTPUT.PUT_LINE ('Result of function xx_fun is ' || v_x);
end;

Report message to a moderator

Previous Topic: Re: ORA-20000 ORU-10027
Next Topic: Re: password encryption and decryption
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 04:47:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.