• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

Testing a simple Oracle PL SQL function using toad sql client?

 
Ranch Hand
Posts: 165
Tomcat Server Java Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi, I'm new to Oracle PL SQL.
there is a function which I need to test. I just need to check the result by printing its output on console by passing few parameters. I'm using Toad here as oracle sql client.

Function which needs to be tested is as follows:-



I seriously don't understand this IN and OUT Parameters.
I think IN parameters are those which I will pass in this function and OUT parameters is the return value from this function, please tell me am I right at this moment?

Right I'm trying to do the testing like by creating a PL SQL procedure and calling this fucntion in that with parameters passing in IN parameters and assuming that I will get some results in OUT parameters and finally I will print those OUT parameters on toad console like:-



Why I'm getting the error? Am I doing the testing in right way? If no, then how?
 
Bartender
Posts: 2662
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Welcome to the Ranch, VinodVijay !
Do you use the correct syntax for creating a function?

I don't see a return clause in your code.

 
reply
    Bookmark Topic Watch Topic
  • New Topic