Passing Dates into stored procedures
Date: 2000/02/22
Message-ID: <88ut7f$o8l$1_at_bob.news.rcn.net>#1/1
Greetings all, i just wrote a procedure in Oracle8. This procedure
takes as one of the passed values a birth date. However, when I
pass the required values to the procedure I get the following error
message:
SQLWKS> execute spAddUser (4, 'FirstName', 'Last Name', 'V', 'Address1',
'Address2', 'City', 'ST', 'ZIP', 840, '09/03/66' , 'M', 0, 'IT', 'E
Commerce');
Her are the contents of my procedure:
CREATE OR REPLACE PROCEDURE spAddUser
IS
BEGIN
VALUES (IinUserId, IvcFirstName, IvcLastName, IchMiddleInitial,
IvcAddress1,
ORA-01843: not a valid month
ORA-06512: at line 2
(
IinUserId IN NUMBER,
IvcFirstName IN VARCHAR2,
IvcLastName IN VARCHAR2,
IchMiddleInitial IN CHAR,
IvcAddress1 IN VARCHAR2,
IvcAddress2 IN VARCHAR2,
IvcCity IN VARCHAR2,
IvcState IN VARCHAR2,
IvcZipCode IN VARCHAR2,
IsiCountryCode IN NUMBER,
IsdBirthDate IN DATE,
IchGender IN CHAR,
ItiMarried IN NUMBER,
IvcOccupation IN VARCHAR2,
IvcIndustry IN VARCHAR2
)
INSERT INTO tbUser (inUserId, vcFirstName, vcLastName,
chMiddleInitial, vcAddress1,
vcAddress2, vcCity, vcState, vcZipCode,
siCountryCode,
sdBirthDate, chGender, tiMarried, vcOccupation,
vcIndustry,
sdDate, tiActive)
IvcAddress2, IvcCity, IvcState, IvcZipCode, IsiCountryCode,
IsdBirthDate, IchGender, ItiMarried, IvcOccupation, IvcIndustry,
SysDate, 1);
END spAddUser;
I would appreciate any help with regards to this matter.
Louis Received on Tue Feb 22 2000 - 00:00:00 CET