rayofhope

[QUOTE=Indianblues;594658]Hi I installed oracle 9i on my system. I am working with sql plus browser. my doubt is how to open iSQL *plus browser. I tried my level best to find out but no use. please any tell me how to open iSQL *plus. Thanks[/QUOTE] If you are opening from …

[QUOTE=DWFENNEL;595669]I have a program that has a connection to an Oracle database and is supposed to execute an Insert statement. It runs with no problem until the [I]connection.Execute SQLString[/I] command. This causes a crash. The code compiles error free, and I've checked the syntax of the Insert statement and it …

Hi cris, Sorry, Dnt know abt data control much. But, Can you execute sql statements using this control like connection.execute method in ADO. If you can, why can't you try data.execute "create user " & txtuser.text & " identified by " & txtpwd.text & " default ............. " Regards

HI swapna, Are you using Winsock control ?? if yes, why dont you try winsock.localIP ?? Regards

[QUOTE=Yogesh Sharma;592526]What is @@rowcount and with small code snippet explain the usage? Is the foll. code is rite-- Create procedure get_emp_count ( @emp_id int) As Select * from emp where emp_id =@emp_id If @@rowcount = 0 Begin Select 'no rows with emp_id= ' Select @emp_id End . Can u pls …