" PLS-00222: no function with name exists in this scope; ORA-06512: No data found "

 Hello,
I am developing a 3-tier based website having Oracle 10g DB at back end. I have Oracle Data Provide fo .net (ODP.net) installed but still error is not being detected. Firstly, i created a pl/sql stored procedure as:
-----------------------------------
create or replace procedure CheckLogin(u_name in varchar2, u_pwd in varchar2,is_admin in number) is
uname varchar2(30);
upwd varchar2(30);
begin
if (is_admin = 0) then
select user_name,password into uname,upwd from cms_users_login
where user_name = u_name and password = u_pwd;
else
select admin_name,password into uname,upwd from cms_admin_login
where admin_name = u_name and password = u_pwd;
end if;
end CheckLogin;
-----------------------------------------------------------------------------------
then i created a DAL (Login.xsd). It contains a query as "CheckLogin" having three parametes: username,password and is_admin.

LoginBLL contains a function to verify login as:
---------------------------------------------------------
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
public Login.CHECKLOGINDataTable VerifyLogin(string username, string userPwd, int? is_admin)
{
return Adapter.CheckLogin(username, userPwd,ref is_admin);
}
-----------------------------------------------------------------------------------
now when i run the login page and enter login info, it gives error
" PLS-00222: no function with name exists in this scope; ORA-06512: No data found "


Should i use package or wrapper stored procedures.Please help....what to do?

Thank you.

0
dialtf
4/22/2009 6:33:25 AM
asp.net.oracle 2269 articles. 0 followers. Follow

3 Replies
1983 Views

Similar Articles

[PageSpeed] 42

Sample like this
...
set cn = Server.CreateObject("ADODB.Connection")
connString = "Provider=MSDAORA.1;Data Source=;User ID=;Password="
cn.Open connString
SQL = "{call test.test_asp({resultset 0, cResult})}"
Set cmd = Server.CreateObject ("ADODB.Command")
Set cmd.ActiveConnection = cn
cmd.CommandText = SQL
cmd.CommandType = 1 'adCmdText
Set rs = Server.CreateObject ("ADODB.RecordSet")
Set rs = cmd.Execute
If NOT (rs.BOF and rs.EOF) Then
Do while NOT rs.EOF
<%=rs("dfcountry")%>
<%=rs("dfname")%>
rs.MoveNext
LOOP
End if
.....
And in package TEST i have
PROCEDURE TEST_ASP(cResult IN OUT ResultCursor)
IS
BEGIN
OPEN cResult FOR
SELECT *
FROM tcountry;
END TEST_ASP;"

If we use a function, it can be
FUNCTION test_fun
RETURN resultcursor
IS
vres resultcursor;
BEGIN
OPEN vres FOR
SELECT *
FROM tcountry;
RETURN vres;
END test_fun;


Many Thanks & Best Regards,
HuaMin Chen

(Mark it as answer if it does help you!)
0
wmec
4/22/2009 7:23:54 AM

 Thank You for ypur reply. but what i want to do is through DAL (.xsd). Any soloution that i use table adapeters and call stored procedures in it?

0
dialtf
4/22/2009 8:53:07 AM

Here is an example (but it's not calling an Oracle function)

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/1999/XMLSchema-instance" xmlns:xsd="http://www.w3.org/1999/XMLSchema">

<soap:Body>
<GetHCNLookup xmlns="http://dev8-kp/MyXMLService/MyXMLService.asmx" soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">

<strSomeParam xsi:type="xsd:string">9</strSomeParam>

</GetHCNLookup>

</soap:Body>

</soap:Envelope>

 

This successfully calls my webservice.

<WebMethod()> <SoapDocumentMethod(Action:="GetHCNLookup")> _
Public Function GetHCNLookupFunctionName(ByVal strSomeParam As string) As XmlDocument

'code here to return some xml. + strSomeParam + "inWebService"

Return dom
End Function

 


Many Thanks & Best Regards,
HuaMin Chen

(Mark it as answer if it does help you!)
0
wmec
4/22/2009 9:11:12 AM
Reply:

Similar Artilces:

Whan can i do? make "string" data type convert to "window" data type, and use a "window" name to get it ancestor "window name", thanks! i use pb5
Rich, With a string window name, you can open a window of that type if you need to. You could, of course, query that window object for any attributes. Another option is to use the LibraryExport function to export the definition of the window which is specified by the string. You can then parse the resulting file to get information on the ancestor object. HTH Sanjiv. "Rich" <windows_ce@netease.com> wrote in message news:2Xsr1WW0AHA.178@forums.sybase.com... > > > ...

How can I access < input type="hidden" name="objHidden" id="objHidden" > from a .net server side function
Topic says it all..please help!! Right Click the control in the design view and select run as server control. ...

Call a function by name in a variable? i.e.: String func = "my_function" func() (that calls the function named "my_function")
 I'm looking for a way to dynamically call functions by name. i.e. what I want to do is this:  1 2 3 Function add_two_plus_two() As Integer 4 Return 2 + 2 5 End Function 6 7 Dim my_function_name As String 8 my_function_name = "add_two_plus_two" 9 10 11 Dim myVal As Integer 12 myVal = my_function_name() // calls the function named "add_two_plus_two" 13 14 Print(myVal) // prints out "4"    Sorry for the sloppy syntax, I'm not a VB.NET programmer by trade. Is there a w...

"data only" "log only" data and log"
i altered the db to include 1 gb. however the fragment was created "data and log". what should have i done to create a 'data only' fragment? melanie wrote: > i altered the db to include 1 gb. > however the fragment was created "data and log". > > what should have i done to create a 'data only' fragment? I believe I'm correct in saying that if your database has data and log on separate devices the alter database command will assume you're adding to "data" unless you specify otherwise by using the "log on&q...

column "name" is not in table "name "
I have a problem with PB 6.5.1, and Informix 5.02 (Online) ... We receive the error above in subject.... when i tried to make a Datawindow updated. (settings) .. I`m not sute what that mean.. I have done all the testing.. and I did not find anything...Please .. help me Carlos BDT-Caracas-Venezuela Carlos, It sounds like the datawindow has a select statement that selects data from multiple tables using a SQL Join. nd perhaps when the update properties were set, columns from multiple tables were selected and marked as updateable columns. I will test this when I get a ...

[PATCH] "Name not found" vs. "No applicable method"
The following patch makes Parrot_get_name report a different error message if Parrot_MMD_search_default_func finds nothing, to distinguish this from the case where nothing is found. I am finding this helpful in debugging. But this seems like a band-aid, for two reasons: 1. find_name can never return a MultiSub, and find_global doesn't seem to work. So I can't get a handle on a MultiSub built for me by IMCC. 2. Even if I had it, I couldn't call it, because the dispatch is done by find_name. Seems to me (IMHO) that the MultiSub invoke method is th...

New trunk XUL Runner: ""function eval must be called directly, and not by way of a function of another name""
I've built fresh trunk XULRunner (cvsupped about a day ago, 4 Dec 2005), and my project stops to work. Previous XUILRunner was about two moths old. I've got error message in console: function eval must be called directly, and not by way of a function of another name And it is for code with real "eval", not any aliases. Here is one trick I use: function, which calls "eval", was loaded in XPCOM context and passed to XUL context via "wrappedJSObject". So, I think, it is reason of this error -- different context on compilation ad execut...

META name="title" + META name="description" + META name="keywords" in MasterPage head section
Hy Guys, I've placed these META tags on the HEAD section of my MASTERPAGE of my application (used in all my webforms) Last Monday week I was on the first page of GOOGLE at the sixth position. Last Friday, I've added a script section on my head too. Something like: function .... .... .... This week, I can't even find my site even if I put on the search engine te exact site name. Did I do something wrong? Does the scrip section stop the google robots to read the META tags? Thank you in advance MarcoMarco First of all, META tags...

How to resolve "ORA-01403: no data found"
When i attempt to delete from a table on which an after delete trigger is defined, i get exception  as follows; OracleException was unhadled by user code:ORA-01403: no data foundORA-06512: at "...TRIGGER_KATILIMEKLE", line11ORA-04088: error during the execution of trigger '...TRIGGER_KATILIMEKLE'  Here is where i get that error on my ASP.NET project: DSource.DeleteParameters.Add("ID",GView.DataKeys[e.RowIndex].Value.ToString());DSource.Delete(); //Here is where i get that OracleException above. BindGrid(); // In this method, i set selectcommand of ...

Changing the "from-name" / "friendly-name" / sender
Hi, I'm not sure what's the correct designation for the object I'm talking about. In my german GroupWise it's the "Von-Name" or in some cases it's called "friendly name". I'm talking about the sender of an E-Mail which is shown in my GroupWise Mailbox, such as "Peter Briggs <p.briggs@mailman.com>"... My question is who to change it to "Peter Briggs, Mailman Inc. <p.briggs@mailman.com>" ... (adding the ", Mailman Inc.") While using GroupWise in the Caching Modus I can change it on my own in ...

uploading a file with perl--->kueri: ------------4CyrMz2ZeGIClwYfFsVdcv Content-Disposition: form-data; name="level" asda ------------4CyrMz2ZeGIClwYfFsVdcv Content-Disposition: form-data; name="major
Dear my friends... I am still new in perl. I am writing perl-cgi application for uploading a file. I did "chmod=20 777 ../../artikel". But I get weird displayed message: " ueri: ------------4CyrMz2ZeGIClwYfFsVdcv Co........ =C3=AE 6=C3=AA=C3=8E]=C3=8B k=C5=A1f=C3=BEx=C3=AE=C2=A3=CB=86=C2=B7=C2=BE = =C3=B0fS4M3>=C2=BA {=C2=BD=E2=80=A1<=C3=93=C3=B6=C3=B9=C2=B3=C2=AE=EF=BF=BD= =C2=AF3=C3=A7=C3=BDG=C3=A8B=C3=B9=3D =E2=80=9E=C2=AC=C3=88=E2=80=BA=C3=B8R= =C6=92..... &=C6=92 =C3=BF=C6=92&m=E2=80=A1=C3=AE=C3=B8'-n n=C3=8A=C3=90J(p=C3=87 9=C3= =A7q=C3=AE=...

Re: uploading a file with perl--->kueri: ------------4CyrMz2ZeGIClwYfFsVdcv Content-Disposition: form-data; name="level" asda ------------4CyrMz2ZeGIClwYfFsVdcv Content-Disposition: form-data; name="m
------=_Part_8036_22519589.1200191593303 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline SGksIFBhdHJpay4KCllvdSBzaG91bGQgcHJvYmFibHkgYmUgdXNpbmcgQ0dJLnBtLiAgSXQgd2ls bCB2YXN0bHkgc2ltcGxpZnkgd2hhdCB5b3UgYXJlCmRvaW5nLiAgVGhlbiwgeW91IGNhbiByZWFk IGFueSBvZiBhIGRvemVuIHNpdGVzIG9uIGRvaW5nIGZpbGUgdXBsb2FkcyB1c2luZwpDR0k7IHNl ZSBzZWFyY2guY3Bhbi5vcmcgZm9yIHRoZSBkZXRhaWxzIG9mIHVzaW5nIENHSS5wbS4KClNlYW4K CgpPbiBKYW4gMTIsIDIwMDggNTo1NCBQTSwgUGF0cmlrIEhhc2lidWFuIDxwYXRyaWtoQHBlbmd1 aW4tdGVrbm9sb2dpLmNvbT4Kd3JvdGU6Cgo+IERlYXIgbXkgZnJpZW5kcy4uL...

.ALLCOL("%COLUMN%", " ", ", ", ", ")
Do you know anyway for me to exclude a subset of columns returned by this function. We have two columns (rec_user and rec_datetime) which are in all of our tables, but when generating triggers I want automatically generate a script which does not include those two columns but does include all other columns in that table. Bruce I should add that I am using PD 9.0.0.580. Bruce "Bruce Lamb" <lamb.bruce@mayo.edu> wrote in message news:6HgI315nCHA.155@forums.sybase.com... > Do you know anyway for me to exclude a subset of columns returned by this > function. ...

Precedence of "where" ("of", "is", "will")?
Nobody on #perl6 today could answer this one. Is: Str | Int where { $_ } the same as: (Str | Int) where { $_ } or: Str | (Int where { $_ }) ? Followup questions, Mr. President: What kind of operators are "where", "of", "is", and "will"? Is there a reason that S03 doesn't list them? What are their precedence(s)? -- Chip Salzenberg - a.k.a. - <chip@pobox.com> Open Source is not an excuse to write fun code then leave the actual work to others. Chip Salzenberg writes: &...

Web resources about - " PLS-00222: no function with name exists in this scope; ORA-06512: No data found " - asp.net.oracle

Resources last updated: 12/8/2015 3:15:49 PM