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

[Vinod Vijay]

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:-

CREATE OR REPLACE FUNCTION FETCH_ORDER_PRODUCT_DATA(
orderNumber IN VARCHAR2, customerNumber IN VARCHAR2, productLine IN VARCHAR2, 
ODNumber OUT VARCHAR2, Line_Number OUT VARCHAR2, ServiceID OUT VARCHAR2, 
BilltoNumber OUT VARCHAR2, AnnualPrice OUT NUMBER, CoverageCode OUT VARCHAR2) 

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:-

begin


declare

CREATE OR REPLACE FUNCTION FETCH_ORDER_PRODUCT_DATA(11208, ABC, C1, 
ODNumber OUT VARCHAR2, Line_Number OUT VARCHAR2, ServiceID OUT VARCHAR2,
BilltoNumber OUT VARCHAR2, AnnualPrice OUT NUMBER, CoverageCode OUT VARCHAR2) 

SET SERVEROUTPUT ON;
DBMS_OUTPUT.PUT_LINE('HERE IS THE RESULT  ' |ODNumber);
DBMS_OUTPUT.PUT_LINE('HERE IS THE RESULT  ' |Line_Number);
DBMS_OUTPUT.PUT_LINE('HERE IS THE RESULT  ' |ServiceID);

DBMS_OUTPUT.PUT_LINE('HERE IS THE RESULT  ' |BilltoNumber);
DBMS_OUTPUT.PUT_LINE('HERE IS THE RESULT  ' |AnnualPrice);
DBMS_OUTPUT.PUT_LINE('HERE IS THE RESULT  ' |CoverageCode);

end;

Why I'm getting the error? Am I doing the testing in right way? If no, then how?

[Jan Cumps]

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.