Oracle Stored Procedure Problem in .NET - C# Discussion Boards

Re: Client Pinging Server

6-Apr-04 3:20

Yes, so long as they expose CCWs, or COM-Callable Wrappers (which is the best way, and VB6 is entirely built on OLE/COM anyway). See Nick's article, Creating a CCW for COM-enabled, non-.NET Applications[^], and read Exposing .NET Framework Components to COM[^] in the .NET Framework SDK.

A few important things to note: explicitly define your class and interfaces GUIDs (using the GuidAttribute), and DO NOT use auto-generated class interfaces. Instead, attribute your class with ClassInterface(ClassInterfaceType.None) and explicitly declare your class interface and implement it as the first interface in the list of interfaces. Make sure you declare your interface as an automation interface by attributing your interface with InterfaceType(ComInterfaceType.InterfaceIsIDispatch) (or ComInterfaceType.InterfaceIsDual). Since VB6 depends on automation, declaring your interface as an IUnknown implementation won't work.

Microsoft MVP, Visual C#
My Articles

Re: Dlls

scadaguy6-Apr-04 3:24

scadaguy

6-Apr-04 3:24

Yes. You'll need to use regasm.exe to register your assembly as a COM dll. Depending on what the public interface looks like you might have to decorate your code with attributes. There is a lot of information and examples on the web. You can also take advantage of COM+ services in the System.EnterpriseServices namespace.

Client Pinging Server

Prasad Anand6-Apr-04 1:04

Prasad Anand

6-Apr-04 1:04

Hello,

I have many servers running on different machines.

My client program will be shown a list box of available servers.
When connection to server is to be done .NET Remoting.

Now, I should continuosly check whether the connected server is still
running and check all the available servers status and delete the
server from the list if it is not running.

How can I do this, using .NET Framework?

Heath Stewart6-Apr-04 3:12

Oracle Stored Procedure Problem in .NET

6-Apr-04 3:12

If you remove it, then you'd have to keep a list elsewhere so that you can always add them later when they're up and running again. I'd just as well leave them in.

As far as checking their up-status, just try connecting to their published remoting objects that you need. If it fails, then the server's not "up". Simply pinging (which would require implementing ICMP or finding some third-party library that already has) them might not tell you enough, since many firewalls don't return pongs or reply with "destination unreachable". It's also possible that the remoting server (a Windows Services, IIS, whatever) is stopped but the server is up, so pinging it would be disjoint and wouldn't give you an accurate assessment of whether or not the remoting objects is available.

Microsoft MVP, Visual C#
My Articles

Member 3350225-Apr-04 23:27

Member 335022

5-Apr-04 23:27

My problem is this, i have a stored procedure in oracle,
and i which authenticates a user on the basis of loginName
and password.

the problem is that when i accesssed it through C#
giving the two parameter as input and one parameter as output.
there is no value return in output parameter.
can some on tell me how to get the output parameter value in my code
Thanks In Advance

//------------- stored procedure name is
===========SecurityPkg.Authenticate=============

PROCEDURE Authenticate(loginName IN VARCHAR2,loginPassword IN VARCHAR2, loginResult OUT INT )
IS
objectId NUMBER := -1;
objectPwd VARCHAR2(100);
passwordExpiredDate DATE;
BEGIN
Select OBJECT_ID,PASSWORD,PASSWORD_EXPIRES INTO objectId,objectPwd,passwordExpiredDate
From Application_User
Where Application_User.Login_Name=loginName;

IF(objectId = -1) THEN
loginResult := ACCOUNT_DOESNOT_EXITS;
END IF;

IF(objectPwd != loginPassword) THEN
loginResult := WRONG_PASSWORD;
End if;

IF(passwordExpiredDate < SYSDATE) THEN
loginResult := PASSWORD_EXPIRED;
END IF;

EXCEPTION
WHEN NO_DATA_FOUND THEN
loginResult := ACCOUNT_DOESNOT_EXITS;

END Authenticate;

//------------------- csharp code that access the above stored procedure of oracle

OracleCommand cmd=new OracleCommand();
cmd.CommandText="Security_Pkg.Authenticate";
cmd.Connection=myConnection;
cmd.CommandType=CommandType.StoredProcedure;

// first param
OracleParameter loginNameParam=new OracleParameter("loginName",OracleDbType.Varchar2);
loginNameParam.Direction=ParameterDirection.Input;
loginNameParam.Value="Ali";

// 2nd param
OracleParameter loginPasswordParam=new OracleParameter("loginPassword",OracleDbType.Varchar2);
loginPasswordParam.Direction=ParameterDirection.Input;
loginPasswordParam.Value="pass";

// 3rd param
OracleParameter loginResultParam=new OracleParameter("loginResult",OracleDbType.Int16);
loginResultParam.Direction=ParameterDirection.Output;
cmd.Parameters.Add(loginNameParam);
cmd.Parameters.Add(loginPasswordParam);
cmd.Parameters.Add(loginResultParam);

cmd.ExecuteNonQuery();

Now when i check the value of loginResultParam, its null.
can any one tell me how to get its value

Re: Oracle Stored Procedure Problem in .NET

Heath Stewart6-Apr-04 3:08

Re: Oracle Stored Procedure Problem in .NET

6-Apr-04 3:08

It should work, according to the documentation. I've also done this many times using the SqlClient, which works similarily (from callers' perspectives). Have you tested your stored procedure using some Oracle command execution environment? I must admit that I don't know much about Oracle (for my own personal reasons) but I know that in SQL Server you have to declare the size of your char arrays, even for parameters declared in the stored procedure, as well as the size of them when declaring your parameters to use with ADO.NET.

Microsoft MVP, Visual C#
My Articles

Jesse Squire6-Apr-04 4:24

Jesse Squire

6-Apr-04 4:24

I believe that the problem lies in your PL/SQL code. The one thing that I notice is that you never assign a default value to the output parameter in your sproc. If none of the If conditions test true, then loginResult is returned with the database default value.

In my testing (VS.NET 2002, Oracle.DataAccess, Oracle 9i), the output parameter defaults to null regardless of data type declaration. By setting loginResult to your default success value before running the Select statement, you should get the desired result.

Hope that helps. Smile | :)

--Jesse

Re: Oracle Stored Procedure Problem in .NET

Bill Dean7-Apr-04 7:17

Bill Dean

7-Apr-04 7:17

Try closing the connection object before you check the output parameter value. I haven't the faintest idea why, but with sql7.0 I get null for output parameters until after I call the close method on the connections...

Someone smarter than I will have to take a shot at why that might be...

Grasping...
Bill

MDIChild from another child form

robmays5-Apr-04 22:12

robmays

5-Apr-04 22:12

need to open a form but it must be an MDIChild ie its menu bar needs to appear on the MDIparent any ideas

private void btnLogin_Click(object sender, System.EventArgs e)
{

if(CheckUser(txtUserName.Text,txtPassword.Text) == 1)
{

SalesForm frm = new SalesForm();
if(MdiParent != null)
{
MdiParent.AddOwnedForm(frm);
frm.Show();
this.Close();

}
}
else
{
throw new Exception("fart");
}

Re: MDIChild from another child form

MeterMan5-Apr-04 22:59

MeterMan

5-Apr-04 22:59

I'm not sure if this is what you want but check this out.
In your child form right click on the mainmenu that you have added.
Hit properties. Once you hit properties for the menu you will see
MergeType
click on this and then change it to MergeItems
This will append the menu to your parent's menu.

I hope this helps.

Win32newb
"Making windows programs worse than they already are"

Re: MDIChild from another child form

LongRange.Shooter6-Apr-04 3:27

LongRange.Shooter

6-Apr-04 3:27

The best way to handle this problem and doing it safely is to create a delegate in the Parent, create an Event in the child, and subscribe the delegate to the event. Then when your child sees that the event for opening the second child occurs, you raise the event and pass the necessary information to be passed to the second child in the event args.

...parent...
MyChild child;
     ...
if (child != null)
{
   child = new MyChild();
   child.SomeEvent += new EventHandler(myDelegateMethod);
   child.MdiParent = this;
   child.Show();
}
else
   child.Focus();
...

private void myDelegateMethod(object sender, MyEventArgs e)
{
        INewChild something;
        if (e.RequestedForm == "Calculate")
            something = new Calculate(e.Args);
        else
            something = new SomethingElse(e.Args);
        something.MdiParent = this;
        something.Show();
}

...
public class MyEventArgs:System.EventArgs
...

______________________________
The Tao gave birth to machine language. Machine language gave birth to the assembler.

The assembler gave birth to the compiler. Now there are ten thousand languages.

Each language has its purpose, however humble. Each language expresses the Yin and Yang of software. Each language has its place within the Tao.

But do not program in COBOL if you can avoid it.

Is string a primitive type??

Ungi.5-Apr-04 20:05

5-Apr-04 20:05

Is string a primitive type or is it not?

I read in Jeffrey Richter's "Applied Microsoft .NET Framework" that string (and decimal too) should be primitive types but than I tried following lines of code:

<br />
string s="";<br />
Console.WriteLine (s.GetType().IsPrimitive.ToString());<br />

It prints false!!

Do I make something false, or does anybody have an explanation for that??

mfg

Corinna John5-Apr-04 21:50

Corinna John

5-Apr-04 21:50

System.String is a class.
AFAIK the pseudo-primitive type string is only a shortcut for System.String.

Ungi.5-Apr-04 21:56

5-Apr-04 21:56

Yes, I know. int is also just a shortcut for System.Int32.

What I'm wondering about is, that Mr. Richter writes in his book, that string is a Primitive type and the command returns false at this method call. It also does with decimal datatype (decimal is no class), but it does not with int.

Milton Karimbekallil6-Apr-04 0:53

Milton Karimbekallil

6-Apr-04 0:53

hi
Just go thru http://www.dotnet247.com/247reference/msgs/37/187311.aspx

rgds..mil10

Ungi.6-Apr-04 2:10

6-Apr-04 2:10

Thanks!! Good explanation Cool | :cool:

It says that string is no primitive type.

But another question:
This discussion also says that only on primitive types consts could be defined; but I am also able to define a string const with the following statement:

private const string cMYCONST = "asdfjkl";

???? Confused | :confused:

Heath Stewart6-Apr-04 2:59

6-Apr-04 2:59

As was already proven about that author, not everyone is as right as they claim to be. Whoever said that is wrong.

You can declare anything as a const that can take a literal value, such as strings and other "primative" types (value types) that don't require explicit instantiation. These are your numeric types, bool, string, and enums.

Microsoft MVP, Visual C#
My Articles

Ungi.6-Apr-04 3:15

6-Apr-04 3:15

Thanks for the answer. I think I understand now a little more about those value/reference types...

Heath Stewart wrote:
As was already proven about that author, not everyone is as right as they claim to be. Whoever said that is wrong.

What do you mean with it, does Jeffrey Richter have more mistakes in his articels than it seem to be there??

Heath Stewart6-Apr-04 3:44

6-Apr-04 3:44

Actually, I was referring to the comment in the discussion someone linked that said that only "primatives" could be declared as consts. The fact that Jeffrey Richter said that String was a primative (and I'm taking your word for it) would be incorrect, yes. The Framework supports that by what you saw (which, BTW, you don't need to use Boolean.ToString in Console.WriteLine, since it formats every argument - regardless of type - as a string anyway; see my article, Custom String Formatting in .NET[^] for a brief discussion, though the article's not about that so much).

Microsoft MVP, Visual C#
My Articles

leppie6-Apr-04 7:18

leppie

6-Apr-04 7:18

I would say string is primitive as it is directly supported in the CLR. Decimal on the hand, is not.

^{top secret}