Home » RDBMS Server » Server Utilities » assigning default value null to IN and OUT variables in a stored procedure for DB2
assigning default value null to IN and OUT variables in a stored procedure for DB2 [message #70550] Thu, 27 June 2002 22:15 Go to next message
kedar nadkarni
Messages: 1
Registered: June 2002
Junior Member
Can someone tell me how to assign null to the IN and
OUT variables passed to a stored procedure for DB2?
The following code does'nt work.
CREATE PROCEDURE ABD.DFG (
OUT sdfg VARCHAR(100) = Null,
.....
Thanks.
Kedar.
Re: assigning default value null to IN and OUT variables in a stored procedure for DB2 [message #70552 is a reply to message #70550] Fri, 28 June 2002 03:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
SQL> ED
Wrote file afiedt.buf

  1  create or replace procedure
  2  test
  3  (C in NUMBER default null)
  4  is
  5  cursor c1 is select * from emp where COMM=C;
  6  begin
  7  for mag in c1 loop
  8  exit when c1%notfound;
  9  dbms_output.put_line(mag.sal);
 10  end loop;
 11* end;
SQL> /

Procedure created.

SQL> EXEC TEST(500);
1250

PL/SQL procedure successfully completed.

SQL> EXEC TEST

PL/SQL procedure successfully completed.

SQL> 
Re: assigning default value null to IN and OUT variables in a stored procedure for DB2 [message #71907 is a reply to message #70550] Mon, 03 February 2003 08:36 Go to previous message
Nathalie vergès
Messages: 1
Registered: February 2003
Junior Member
Je voudrai mettre un parametre de type RECORD en parametre optionel d'une procédure stockée en PL/SQL
Comment faire?

J'ai essayé
--
-- Structure message INTERVENTION envoyee par PRIMA ACTIVITE
--
TYPE REC_INTERV IS RECORD (
nIntervid NUMBER(12), -- ID intervention - obligatoire
vTitre VARCHAR2(32),
vSalle VARCHAR2(6),
dSalleDent DATE, -- Date d entree salle (heure incluse)
dSalleDsor DATE, -- Date de sortie salle (heure incluse)
dIntervDent DATE, -- Date debut intervention (heure incluse) - obligat
oire
dIntervDsor DATE, -- Date de fin intervention (heure incluse) - obliga
toire
vIntervUg VARCHAR2(4), -- UG
vAnesid VARCHAR2(6), -- Code agent de l'anesthesiste
vAnesLib VARCHAR2(50), -- Libelle anesthesiste
vAnesUf VARCHAR2(4), -- UF d anesthesie
vAnesDate DATE, -- Date et heure d anesthesie
vLiberal VARCHAR2(1) -- Liberal o/n
);

et dans le corps du package :

Procedure LectActe(par_typemsg IN CHAR,
par_acte IN REC_ACTE,
par_interv IN REC_INTERV default NULL,
par_pfierr IN OUT NUMBER,
par_apperr IN OUT NUMBER,
par_appmsg IN OUT VARCHAR2)
Mais ca ne marche pas. Pouvez vous m'aider?
Previous Topic: Archivelog List Problem
Next Topic: Importing Oracle 8.1.7 dump file into Oracle 8.1.6
Goto Forum:
  


Current Time: Tue May 14 21:03:49 CDT 2024