Issue with executing a Oracle 11g Stored procedure from ASP.NET page

Posted on 2012-09-11
Last Modified: 2012-09-17

I am migrating a web application developed in ASP.NET working in 32 bit platform with IIS6.5 and with Oracle 11g to an ASP.NET app targeted to work in 64 bit platform with IIS7 & same Oracle 11g now in 64 bit Windows Server 2008 platform.

When executing my stored procedure, STEQA44IU, I am getting the following error:
ORA-06550: line 1, column 7: 
PLS-00306: wrong number or types of arguments in call to 'STEQA44IU' 
ORA-06550: line 1, column 7: 
PL/SQL: Statement ignored

Open in new window

The message above is generic & I dont understand the reasons as there is no change in the code or in the stored procedure in the database.
My .NET platform is 3.5 service pack 1.

I am using Oracle OLEDB provider to connect & execute the stored procedure.

What could be the problem?
Am I supposed to change the data types from ASP side for 64 bit?
Should I check Oracle 11g stored procedure & alter this specifically for 64 bit?

Your earliest reply will be of great help.
    LVL 16

    Accepted Solution

    the problem is not with the .Net code.. i think this error came out from the stored procedure STEQA44IU

    the input parameters/output parameters does not match with the call made from your code..

    check out the parameters used in the code and the actual parameters present for the procedure in database..
    LVL 12

    Assisted Solution

    I agree it is related to the arguments you are passing to your procedure.

    If you are confident that this call with the same arguments would have worked under your old setup,  could it be a type conversion issue on your new system?    e.g. default date formats are different in your new setup.

    If any of your parameters are date related,  that is where I would start looking.

    Author Comment

    The problem is with the cursor type set. The parameter values are taken from DB and passed. If the cursor type is adUseClient, the problem is getting rectified.

    If we use asUseServer, only one record is returned and we are getting the error.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    26 Experts available now in Live!

    Get 1:1 Help Now