FAQ: Calling stored procedures with record type parameters

This is not directly possible. Direct Oracle Access does not have record type variables, because Oracle does not publish information about this feature. One work around is to create a small PL/SQL block that has only input and/or output variables of a scalar data type, that are converted to/from a locally define record variable that is passed to the procedure:

[quote]

Code

declare
  dr dept%rowtype;
begin
  -- Copy from scalar variables if the record is an input parameter
  dr.deptno := :deptno;
  dr.dname := :dname;
  dr.loc := :loc;
  -- Call the procedure with the local record
  myproc(dr);
  -- Copy to scalar variables if the record is an output parameter
  :deptno := dr.deptno;
  :dname := dr.dname;
  :loc := dr.loc;
end;

[/quote]