SQL & PL/SQL

Hi All,

I have a procedure that takes IN an object as the parameter. I'm using SQL Developer , and also have SQL*plus.


The type is


create or replace
TYPE TY_RAILROAD_OPERATOR AS OBJECT
(
RRX_RAILROAD_OPERATOR_CD VARCHAR2(6 BYTE),
RRX_RAILROAD_OPERATOR_NM VARCHAR2(60 BYTE) ,
RRX_RAILROAD_OPERATOR_DSC VARCHAR2(2000 BYTE),
STATUS CHAR(1 BYTE),
LAST_UPDATE_DT DATE,
LAST_UPDATE_USER VARCHAR2(60))



procedure set_Railroad_Operator(p_TY_Railroad_Operator IN TY_Railroad_Operator, p_Railroad_Operator_Id OUT NUMBER) IS

v_Railroad_Operator_Id NUMBER;

BEGIN
..
.
.
I have to execute the procedure. How should I pass the parameters?

I would like to test the procedure, and I have no idea how to test it.

Any help is appreciated.


Thanks in advance
N