473,387 Members | 1,579 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Help in calling Oracle Package from aspx page

Hi,

I'm, trying to call a package from my page to populate a datagrid. I'm using an example from the web, but I can't get it to work.

Here is my code:

code in the aspx page:
....
OracleConnection cnnOracle = new OracleConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
cnnOracle.Open();
OracleCommand oraCmd = new OracleCommand("{call PACKPERSON.AllPerson({resultset 10,ssn,fname,lname})}",cnnOracle);
oraCmd.CommandType = CommandType.StoredProcedure;
DataSet dstPerson = new DataSet();
OracleDataAdapter adpPerson = new OracleDataAdapter(oraCmd);
adpPerson.Fill(dstPerson);
this.DataGrid1.DataSource= dstPerson;
this.DataGrid1.DataBind();
....

When I run my application I get the following error:

ORA-06550: line 1, column 7: PLS-00103: Encountered the symbol "{" when expecting
one of the following: begin case declare exit for goto if loop mod null
pragma raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
<< close current delete fetch lock insert open rollback savepoint set sql
execute commit forall merge <a single-quoted SQL string> pipe

Any suggestion are welcome.
Thanks
Garfield
Nov 15 '05 #1
0 2156

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Rick | last post by:
Package header named RecordSetPKG as follows as --Package defines the type ref cursor stored procedures will use varables of this type to stored --multple records back to the calling stored...
10
by: s_gemberling | last post by:
I am connecting to Oracle 9i via an ASP page using the ORacle OLEdB driver (OraOLEDB). When I try to execute the following vbscript code in ASP my page hangs(no timeouts, no errors, etc.) It just...
1
by: Jason Leiser | last post by:
Is there a way to call an Oracle Procedure using the MS OLD DB Provider for Oracle object in a SQL Server 2000 DTS package? If it can't be done this way, is there another way to retrieve data from...
0
by: Garfield | last post by:
Hi, I'm, trying to call a package from my page to populate a datagrid. I'm using an example from the web, but I can't get it to work. Here is my code: code in the aspx page: .......
5
by: petro | last post by:
Hello all, My asp.net web application works on my machine but I get the following error on our test web server, There is only one oracle home on the test server. Does anyone know how to resolve...
6
by: JV | last post by:
A ref cursor data type can obviously be returned as an output parameter of a stored procedure, but can an ASP.NET application call an oracle proc that uses a ref cursor as an input parameter? If...
0
by: gunimpi | last post by:
http://www.vbforums.com/showthread.php?p=2745431#post2745431 ******************************************************** VB6 OR VBA & Webbrowser DOM Tiny $50 Mini Project Programmer help wanted...
1
by: cwendell | last post by:
Hello; I am a DBA working on a new project with a developer using .NET and C#. I have created a Package (RECORDER_API) with a very simple Procedure in it (add_row). This package is owned by...
1
by: D.Stone | last post by:
I wonder if anyone could offer some guidelines on the following problem? I need to transfer records from a SQL Server table to an 'equivalent' Oracle table; however if the primary key for any...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.