No size. This is stored procedure out parameter. Oracle will not allow you
declare the size of a stored procedure parameter. See the stored procedure
below.
************************************ Stored Procedure Code:
********************************
procedure GetSysDate( QFromDate OUT VARCHAR2,
QToDayDate OUT VARCHAR2,
QNumDateBack IN NUMBER DEFAULT 60)
is
ToDate VARCHAR2(10);
FromDate VARCHAR2(10);
begin
QFromDate := NULL;
QToDayDate := NULL;
begin
select to_char(sysdate,'MM/DD/YY') INTO ToDate FROM DUAL;
QToDayDate:= ToDate;
select to_char(sysdate - QNumDateBack,'MM/DD/YY') INTO FromDate FROM
DUAL
QFromDate := FromDate;
end;
end GetSysDate;
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257257
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
