RE: Errors while inserting into long data type


Mallik [mailto:mkodiche@xxxxxxxxx] wrote:
>
> Hi Friends,
>
> I am using oracle database and I have column of long data type. I insert
> the
> data into this column thru perl script. If the inserted data exceeds 4000
> chars, it is giving me the following error.
>
> DBD::Oracle::st execute failed: ORA-01704: string literal too long (DBD
> ERROR: OCIStmtExecute) at MT/TACDbManager.pm line 445.
>
> Whereas we can insert upto 2GB of data in long data type.

Let's see your code. I suspect you're not using bind_param() with an
explicit ORA_TYPE, as described in the DBD::Oracle documentation.

Ronald


.

Relevant Pages

  • Re: how to gain numbers
    ... dear friends i do know to use Text data type instead of number data type if ... i am not using that field for calculation but dear friends i am using the ... In the second column of the design grid, next to the name, you can select the ... *better* than a Number field in that you can store leading zeros. ...
    (microsoft.public.access.queries)
  • Re: how to refresh objects if a column changes
    ... Look at the INFORMATION_SCHEMA.ROUTINES view and perform a wildcard search ... in the ROUTINE_DEFINITION column for the column name whose data type ... > Hi friends ... this column so that i could modify them to reflect new chnage? ...
    (microsoft.public.sqlserver.programming)
  • Re: date and datetime
    ... > But when I connect from VFP using DSN, it returns the value as date/time. ...
    (microsoft.public.fox.vfp.dbc)
  • Re: Need loop guidance
    ... "Ronald R. Dodge, Jr." ... Dim arrlngSPAs Long, arrlngTotalAs Long, I as Long ... Also, if your data type isn't long integer, then be sure to adjust your data ...
    (microsoft.public.excel.programming)
  • Re: how to get datatype of columns of a table in perl script
    ... I am developing perl script which connects to oracle database and selects rows from a table and then inserts them into its corresponding table in db2. ... Any database should be able to handle this regardless of the data type. ... A great introspection feature. ...
    (perl.dbi.users)