Results 1 to 4 of 4
  1. #1
    Join Date
    May 2007
    Posts
    8

    Unanswered: calling Functions from sqlplus

    Hi,

    I'm calling a function from the SQLPlus prompt, I dont think it can see the function at all, is there a way to check what directory I need to be in or if SQLPlus has access to the package the function is stored in?

    Thanks

    SQL> select get_xml('XX') from dual;
    select get_xml('XX') from dual
    *
    ERROR at line 1:
    ORA-00904: "GET_XML": invalid identifier

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    The current directory it not relevant at all for calling a function or procedure, why do you think it would be relevant?

    To check all functions and procedures that the current user has access to, try
    Code:
    SELECT * FROM all_procedures
    If get_xml does not show up there, it was either not created or you don't have execute rights for it (in case it was created by a different user)
    For more details on the available system views check the reference manual (Part II Static Data Dictionary Views)

  3. #3
    Join Date
    May 2007
    Posts
    8
    Thanks, It does show up in the SELECT * FROM all_procedures where procedure_name like 'GET_XML';

    I thought it must be the paths that were incorrect as i want to test a function by passing in a varchar

    SQL> select GET_XML('XX') from dual;
    select GET_XML('XX') from dual
    *
    ERROR at line 1:
    ORA-00904: "GET_XML": invalid identifier

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Which schema is logged in & trying to execute the function?
    Which schema owns the "GET_XML" function?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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