Home » SQL & PL/SQL » SQL & PL/SQL » How to pass objects to oracle stored procedure
How to pass objects to oracle stored procedure [message #39120] Tue, 18 June 2002 08:34 Go to next message
Meena Taneja
Messages: 1
Registered: June 2002
Junior Member
Can somebody please send me an example of how I can pass an object to a stored procedure.

Thanks..
Re: How to pass objects to oracle stored procedure [message #39133 is a reply to message #39120] Tue, 18 June 2002 15:42 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you can do something like this
SQL> ed
  1  CREATE TYPE EMPLOYE AS OBJECT
  2  (name VARCHAR2(9),
  3* empNum VARCHAR2(9));
SQL> /

Type created.

SQL> ed
Wrote file afiedt.buf

  1  CREATE OR REPLACE PROCEDURE employe_proc(
  2  emp IN EMPLOYE,
  3  newEmp OUT EMPLOYE) IS
  4  BEGIN
  5  newEmp := EMPLOYE('scoot','tiger');
  6  newEmp.name := emp.name;
  7* END employe_proc;
SQL> /

Procedure created
Previous Topic: Re: retrieving data from an OUT parameter
Next Topic: desparate for some trigger help!
Goto Forum:
  


Current Time: Fri Apr 26 01:55:03 CDT 2024