Error in query (Using JDeveloper9)

Discussion in 'Software' started by jeganathan, Jun 10, 2008.

  1. jeganathan

    jeganathan

    Joined:
    Jun 10, 2008
    Messages:
    2
    Hi friend,
    I am using JDeveloper9 now. First i used JDeveloper10 and developed the project. Now i want to convert the code created with JDeveloper10 to JDeveloper9.

    The error i am facing is
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT fnd_profile.value_specific(?, ?, ?, ?, ?) FROM dual

    The code i wrote is
    public String getProfileValue(String profileName, int userId, int orgId,
    int applId, int respId) {
    String profileVal = "";
    PreparedStatement pst = null;
    ResultSet rs = null;

    try {
    StringBuffer query = new StringBuffer();
    query.append("SELECT fnd_profile.value_specific(?, ?, ?, ?, ?)\n");
    query.append(" FROM dual\n");

    pst =
    connection.createPreparedStatement(query.toString(), connection.DEFAULT);

    pst.setString(1, profileName);
    pst.setInt(2, userId);
    pst.setInt(3, respId);
    pst.setInt(4, applId);
    pst.setInt(5, orgId);

    rs = pst.executeQuery();

    if (rs.next()) {
    profileVal = rs.getString(1);
    }
    } catch (SQLException e) {
    throw new OAException(e.getMessage());
    } finally {
    DatabaseUtilities.close(pst, rs);
    }

    return profileVal;
    }
     
    jeganathan, Jun 10, 2008
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?TWljaGFlbA==?=

    Error using DOS window, ever seen this error?

    =?Utf-8?B?TWljaGFlbA==?=, Apr 15, 2004, in forum: Microsoft Certification
    Replies:
    1
    Views:
    619
    Marlin Munrow
    Apr 15, 2004
  2. Ismaiel
    Replies:
    0
    Views:
    6,162
    Ismaiel
    Oct 26, 2004
  3. JIm

    Backup query using Microsoft backup wizard

    JIm, Sep 21, 2005, in forum: Computer Support
    Replies:
    0
    Views:
    529
  4. jeganathan

    Error in query (Using JDeveloper9)

    jeganathan, Jun 10, 2008, in forum: NZ Computing
    Replies:
    0
    Views:
    434
    jeganathan
    Jun 10, 2008
  5. Ali_ggl
    Replies:
    0
    Views:
    1,177
    Ali_ggl
    Nov 29, 2008
Loading...

Share This Page