Watch, Follow, &
Connect with Us
Public Report
Report From: Kylix/Database/dbExpress/TSQLStoredProc    [ Add a report in this area ]  
Report #:  3413   Status: Open
ORA-06550 when Oracle stored function is called.
Project:  Kylix Build #:  4.186
Version:    3.0 Submitted By:   Andrew Fionik
Report Type:  Basic functionality failure Date Reported:  1/23/2003 8:03:38 AM
Severity:    Serious / Highly visible problem Last Updated: 3/20/2012 2:24:39 AM
Platform:    Kylix Pascal IDE Internal Tracking #:   158477
Resolution: None  Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: (1 Total Rating)
4.00 out of 5
Total Votes: None
Description
Calling Oracle stored function returns ORA-06550 with message additional message "PLS-00306: wrong number or types of arguments"

This happens on all versions of Kylix with Oracle 8.0.5, 8.1.6, 9.2.

Steps to Reproduce:
1. Create sample application.
2. Place TSQLConnection and TSQLStoredProc on the Form or DataModule and link stored procedure to connection.
3. Connect with SQLConnection to any Oracle database.
4. Enter manually name of stored function and press button near parameters value, to see that parameters are taken from metadata.
5. Try to execute stored function from code.

Expected behavior: function runs
Actual behavior: execution of function returns error ORA-06550
Workarounds
Instead of using stored function use stored procedure written as below:

create or replace procedure ProcedureName(Param1 in number, Param2 in number,...,Result out number)
as
begin
...
end.
Attachment
None
Comments

None

Server Response from: ETNACODE01