Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to get "...WHERE test IN (5,23,2,12,56)" in this order
Hello,
this function works on my server, but I cannot create it on the production
server.
This is a CMS which is connected through OCI to Oracle. There I can do any
queries and DDL but if I try to create a function, i get an error.
But error number is 000000 ("normal, successful completion")...?.
Could there be a solution without a function?
Thank you!
Dirk
"andrija" <ar35644_at_fer.hr> schrieb im Newsbeitrag
news:a1k3b4$e2ah$1_at_as201.hinet.hr...
> > Andrija,
> >
> > thank you!!
> > May not look that elegant but is a perfect workaround for me.
> > (Why isn't there a possibility inside Oracle or a predefined
function...?)
> >
> > greetings, Dirk
>
> That's why there are user-defined functions. Oracle can not predict all
> functions that you might need. So, you can write them yourself.
>
> Don't let me start about SQL Server, in 7.0 there were no user defined
> function, this problem would be solved with two stored procedures and a
> temporary table... But that's another story.
>
>
>
Received on Thu Jan 10 2002 - 08:52:58 CST
![]() |
![]() |