Dynamic SQL probelm - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Dynamic SQL probelm

Author

Topic

ramana123
Yak Posting Veteran

57 Posts

Posted - 2005-07-08 : 05:56:50

hi all,

i written one stored procedre in Oracle
it will take 3 params.
i posted my code here...
create or replace procedure ENTITY_DEL(IN_UNIQUEKEY_COLUMN_NAME IN VARCHAR,IN_TABLE_NAME IN VARCHAR,IN_UNIQUEKEY IN VARCHAR)IS
a char(12);
b varchar(20);
BEGIN
a:=IN_TABLE_NAME;
b:=IN_UNIQUEKEY_COLUMN_NAME;
execute immediate 'SELECT rowid FROM a WHERE b=IN_UNIQUEKEY' ;
END;

here the table name will be supplied at the time runnig the C# application.It passing parameters correctly.But this SP unable to process that pareams..hence the C# App shows error like..
"Table Or View doent exits"

Pls help me out!!!!

advanced thanks..
ramns123

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-07-08 : 06:06:06

You need to convert your Oralce query to SQL Server query
See more information in Books On Line on how to write stored procedure

Madhivanan

Failing to plan is Planning to fail

ramana123
Yak Posting Veteran

57 Posts

Posted - 2005-07-08 : 06:19:11

hi Madhivanan,
Pls understand the problem clearly..
my problem is written that in Oracle ...
My Application also need to work on Oracle right.

the Problem is whenever i am executed this application at the moment that SP executed in C# code it was given this error..'

"table or View doesnt exist"

that is the Problem.When i see that Parameters list in Quck Watch it passing existing values in database.But the problem is only SP.I am unable to find the Problem...

So where the problem is pls..And giv the Solution for that!!!!

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-07-08 : 06:50:42

Make sure you are supplying the existing table name to the parameter

Madhivanan

Failing to plan is Planning to fail

ramana123
Yak Posting Veteran

57 Posts

Posted - 2005-07-08 : 06:54:46

Hi sure abt that..

my c# code passing vaslues like "ID","resources",566 for to the SP..
its absolutely correct.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-07-08 : 06:58:11

You should probably post your question on an Oracle forum, SQL Team is an MS SQL Server forum. Try here:

http://dbforums.com/