Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    California
    Posts
    58

    Call Oracle function in Crystal Reports

    Hi,
    Is it possible to call an Oracle function (not procedure) which is part of a package from crystal report 8.5. I am trying to access a function in another schema which is part of a package, I have been given execute rights on this package. I can access the function from the SQL prompt. However when i try to add the function in Crystal Reports, I get an error PLS-00201:'Identifier abc.abc should be identified'. Please help! Maybe i need some other priviliges on the object.

  2. #2
    Join Date
    Mar 2004
    Location
    California
    Posts
    58

    Nevermind

    I figured it out. If anyone else has the same problem, you just use the function in the SQL expression. And then use that expression in a formula field

Posting Permissions

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