1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

getting double quotes in last query

Discussion in 'SQL PL/SQL' started by member.forums@gmail.com, Oct 6, 2009.

  1. member.forums@gmail.com

    member.forums@gmail.com Active Member

    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    80
    Hi

    I get the last query executed using the ora_sql_txt (sql_text) function for some auditing.
    Now on some server I get the last query as

    select columnname from "schemaname"."tablename";
    i.e I get double quotes as extra.

    while on some I get without double quotes
    select columnname from schemaname.tablename;

    Is there some setting in oracle for this.

    I am using oracle 10g

    Sapan
     
  2. tyro

    tyro Forum Genius

    Messages:
    368
    Likes Received:
    20
    Trophy Points:
    260
    Location:
    India
    How can we tell if you don't give us the code of the function ora_sql_txt?
     
  3. member.forums@gmail.com

    member.forums@gmail.com Active Member

    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    80
    FOR i IN 1 .. NVL (ora_sql_txt (sql_text), 0)
    LOOP
    stmt_ := stmt_ || sql_text (i);
    END LOOP;

    where
    sql_text ora_name_list_t;
    stmt varchar2(2000);


    This is the part of an on servererror trigger

    ora_sql_text is a oracle function
    CREATE OR REPLACE function SYS.sql_txt (sql_text out ora_name_list_t)
    return binary_integer is
    begin
    return dbms_standard.sql_txt(sql_text);
    end;
     
  4. debasisdas

    debasisdas Active Member

    Messages:
    46
    Likes Received:
    3
    Trophy Points:
    90
    Location:
    Bangalore, India
    where is the source code for ora_sql_txt ?