Error 557

Question

Post reply

Error 557

dB-226266

Ten Centuries

Points: 1298
More actions
April 20, 2005 at 9:44 pm

#68974

Only functions and extended stored procedures can be executed from within a function.

I have a function that calls a stored procedure that I made when I tried to test run the function the above error was generated... how do I get around this problem?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

philcart SSC-Forever Points: 47794 More actions · Answer 1

Does you have to have a function that calls the procedure? Can you change your function to a stored procedure instead?

--------------------
Colt 45 - the original point and click interface

dB-226266 Ten Centuries Points: 1298 More actions · Answer 2

Well the oracle code is written in this way (an sp is called within the function... )

and well I can't just suggest ways to do this because I haven't seen the entire set of plsql packages that uses this... I'll just have to tell my supervisor and let him do the worrying hehehe.. tnx.

philcart SSC-Forever Points: 47794 More actions · Answer 3

This is just the sort of thing I was meaning in my post on your other thread

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=175907#bm176305

Programming something a certain way, because the other system has it that way is probably going to cause you more grief in the long run.

--------------------
Colt 45 - the original point and click interface

dB-226266 Ten Centuries Points: 1298 More actions · Answer 4

Yup I guess you're right... hmmm... but its not by choice you know

Now I'm having a problem with reading files in T-SQL.. I was thinking of using some extended stored procedure... or BCP... but I don't even know how to start it.

philcart SSC-Forever Points: 47794 More actions · Answer 5

Take a look at the T-SQL BULK INSERT command.

--------------------
Colt 45 - the original point and click interface

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 6

I think a nice analogy to think of is how texts are translated. If you would take an English text and start translating it into another language, Swedish for example, and just translate it word by word you would get a very weird result. It might have the same basic meaning, and it would probably still be possible to understand it if you know Swedish, but it would definitely not be a good translation.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

Michael Du Bois SSCertifiable Points: 5163 More actions · Answer 7

I agree with Phill. Perhaps you are approaching the problem in the wrong manner. IMHO I would suggest:

1. Define the desired output

2. Determine the needed inputs

3. Forget the Orcal code

4. Then extract the needed data straight from the DB and perform what ever functions needed to get the desired output.

Another possible approach would be to forget T_SQL and write the code in Orcal SQL/PL.

Mike