This is a multi-part message in MIME format.
------=_NextPart_000_001D_01C401B9.CFCC3260
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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 =3D new =
OracleConnection(ConfigurationSettings.AppSettings["ConnectionString"]); =
cnnOracle.Open();
OracleCommand oraCmd =3D new OracleCommand("{call =
PACKPERSON.AllPerson({resultset 10,ssn,fname,lname})}",cnnOracle);=20
oraCmd.CommandType =3D CommandType.StoredProcedure;
DataSet dstPerson =3D new DataSet();
OracleDataAdapter adpPerson =3D new OracleDataAdapter(oraCmd);
adpPerson.Fill(dstPerson);
this.DataGrid1.DataSource=3D 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>=20
<a double-quoted delimited-identifier> <a bind variable>=20
<< close current delete fetch lock insert open rollback savepoint set =
sql=20
execute commit forall merge <a single-quoted SQL string> pipe=20
Any suggestion are welcome.
Thanks
Garfield
------=_NextPart_000_001D_01C401B9.CFCC3260
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm, trying to call a package from my =
page to=20
populate a datagrid. I'm using an example from the web, but I can't =
get it=20
to work.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Here is my code:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>code in the aspx =
page:<BR>...<BR> =20
OracleConnection cnnOracle =3D new=20
OracleConnection(ConfigurationSettings.AppSettings["ConnectionString"]);&=
nbsp;</FONT></DIV>
<DIV>
<P><FONT face=3DArial size=3D2> =
cnnOracle.Open();<BR> =20
OracleCommand oraCmd =3D new OracleCommand("{call =
PACKPERSON.AllPerson({resultset=20
10,ssn,fname,lname})}",cnnOracle); <BR> =
oraCmd.CommandType =3D=20
CommandType.StoredProcedure;<BR> DataSet dstPerson =3D new=20
DataSet();<BR> OracleDataAdapter adpPerson =3D new=20
OracleDataAdapter(oraCmd);<BR> =20
adpPerson.Fill(dstPerson);<BR> this.DataGrid1.DataSource=3D=20
dstPerson;<BR> this.DataGrid1.DataBind();<BR>...</FONT></P>
<P><FONT face=3DArial size=3D2>When I run my application I get the =
following=20
error:</FONT></P>
<P><FONT face=3DArial size=3D2>ORA-06550: line 1, column 7: PLS-00103: =
Encountered=20
the symbol "{" when expecting<BR> one of the following: begin case =
declare=20
exit for goto if loop mod null <BR>pragma raise return select update =
while with=20
<an identifier> <BR><a double-quoted delimited-identifier> =
<a=20
bind variable> <BR><< close current delete fetch lock insert =
open=20
rollback savepoint set sql <BR>execute commit forall merge <a =
single-quoted=20
SQL string> pipe </FONT></P></DIV>
<DIV><FONT face=3DArial size=3D2>Any suggestion are =
welcome.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
<DIV><FONT face=3DArial =
size=3D2>Garfield</FONT></DIV></FONT></DIV></BODY></HTML>
------=_NextPart_000_001D_01C401B9.CFCC3260--