The date is copied to the out parameter at line 99.
LINE TEXT
----------
-----------------------------------------------------------------------------------------
95 QToDayDate := NULL;
96
97 begin
98 select to_char(sysdate,'MM/DD/YY') INTO ToDate
FROM DUAL;
99 QToDayDate:= ToDate;
100 select to_char(sysdate -
QNumDateBack,'MM/DD/YY') INTO FromDate
101 from dual;
102 QFromDate := FromDate;
103
104 end;
105
On 10/11/06, Tom Chiverton <[EMAIL PROTECTED]> wrote:
>
> On Wednesday 11 October 2006 02:02, Jack Shepard wrote:
> > Socket][Oracle][ODBC][Ora]ORA-06502: PL/SQL: numeric or value error:
> > character string buffer too small ORA-06512: at "MY.RETRIEVEPROC", line
> 99
> > ORA-06512: at line 1
>
> What's line 99 then ?
>
> --
> Tom Chiverton
> Helping to professionally market internet market-growth
>
> ****************************************************
>
> This email is sent for and on behalf of Halliwells LLP.
>
> Halliwells LLP is a limited liability partnership registered in England
> and Wales under registered number OC307980 whose registered office address
> is at St James's Court Brown Street Manchester M2 2JF. A list of members is
> available for inspection at the registered office. Any reference to a
> partner in relation to Halliwells LLP means a member of Halliwells LLP.
> Regulated by the Law Society.
>
> CONFIDENTIALITY
>
> This email is intended only for the use of the addressee named above and
> may be confidential or legally privileged. If you are not the addressee you
> must not read it and must not use any information contained in nor copy it
> nor inform any person other than Halliwells LLP or the addressee of its
> existence or contents. If you have received this email in error please
> delete it and notify Halliwells LLP IT Department on 0870 365 8008.
>
> For more information about Halliwells LLP visit www.halliwells.com.
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:256370
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
