Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    kl
    Posts
    2

    Talking Unanswered: Urgent Help required ORA-01747 error

    Hi to all oracle, coldfusion gurus
    Using coldfusion, i can succesfully retrieve records. However, when i update, i get the ora-01747 message.
    The cold fusion script is below
    <cfset ps_table_prefix="EHRADM">
    <cfset this.psprefix=ps_table_prefix>
    <cfset this.psdatasource="EHRANDPS">
    <cftry>
    <cfquery datasource="#this.psdatasource#" name="Update_Personal">
    UPDATE
    #this.psprefix#.PS_PERSONAL_DATA
    SET
    ADDRESS1=<cfqueryparam value="#qrData.HomeAddress1#" cfsqltype="cf_sql_varchar" >,
    WHERE
    EMPLID=<cfqueryparam cfsqltype="cf_sql_varchar" value="#qruserData.emplid#">
    </cfquery>
    <cfcatch type="database">
    <cfoutput>"Database Personal_data error has occured"</cfoutput>
    <cfoutput>#cfcatch.errorcode#,#cfcatch.Message#,#c fcatch.Detail#</cfoutput>
    <cfabort>
    </cfcatch>
    </cftry>

    The error message is below
    "Database Personal_data error has occured" HY000,Error Executing Database Query.,[Macromedia][Oracle JDBC Driver][Oracle]ORA-01747: invalid user.table.column, table.column, or column specification

    However all the tables, user and columns exist as proven by the select table.

    All possible suggestions are graciously welcome.

  2. #2
    Join Date
    Sep 2007
    Posts
    1

    ORA Error 01747

    Same Error, same programming stack.

    A value I was passing to a query, had a #NumberFormat(query.value)# formatting on it. It was passing 1,500 vs. 1500.
    The error occured because the datatype in the database was number(11),
    and the comma (1,500) from the NumberFormat() formatting was throwing it off.

    I took off the NumberFormat() and just passed #query.value# and the problem went away.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •