Hi,
does anyone know if, and how, I can return a record (set) from a stored
procedure/function?
What does the function have to do?
well at this moment I'm porting our product's database based global registry
from SQL Server to Oracle10g (as it has to work on both). Now I have a
function called CreateKey, which like the name says creates a single key
entry in the global registry. Afterwards it has to return with the created
key (a single row) and it's newly generated globally unique identifier, but
if the key already existed it should return with the existing key
information.
Could someone please help me?
ps. I'm using Oracle10g.
Thanx,
Alexander
2  9817 
"Alexander Pino" <Al************@cea-int.com> wrote in message
news:40***********************@news.xs4all.nl... Hi,
does anyone know if, and how, I can return a record (set) from a stored
procedure/function?
What does the function have to do?
well at this moment I'm porting our product's database based global
registry from SQL Server to Oracle10g (as it has to work on both). Now I have a
function called CreateKey, which like the name says creates a single key
entry in the global registry. Afterwards it has to return with the created
key (a single row) and it's newly generated globally unique identifier,
but if the key already existed it should return with the existing key
information.
Could someone please help me?
ps. I'm using Oracle10g.
Thanx,
Alexander
Look up ref cursor in the docs as an out parameter.
Jim
Probably I should have mentioned that I want to use it in combination with
..NET and C# in particularly.
Alexander
"Alexander Pino" <Al************@cea-int.com> wrote in message
news:40***********************@news.xs4all.nl... Hi,
does anyone know if, and how, I can return a record (set) from a stored
procedure/function?
What does the function have to do?
well at this moment I'm porting our product's database based global
registry from SQL Server to Oracle10g (as it has to work on both). Now I have a
function called CreateKey, which like the name says creates a single key
entry in the global registry. Afterwards it has to return with the created
key (a single row) and it's newly generated globally unique identifier,
but if the key already existed it should return with the existing key
information.
Could someone please help me?
ps. I'm using Oracle10g.
Thanx,
Alexander
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: deanbrown3d |
last post by:
Hi there!
Suppose I have a function
void ShowMessage(string s);
(that has a void return type.)
In my other function F, also with a void return type, can I do this?
|
by: kathy |
last post by:
how to return array from function?
|
by: ifrst |
last post by:
What's the defrrence between these(sub,procedure,function,private)
and when i use them
Als
i know it can be function ,sub or procedure Public or private so what does it mean Private only such as...
|
by: msolem |
last post by:
I have some code where there are a set of functions that return
pointers to each other. I'm having a bit of a hard time figuring out
the correct type to use to do that.
The code below works but...
|
by: kaushikroy |
last post by:
i m getting this error when i m executing a stored procedure
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
can anyone help me out what exactly the...
|
by: CoolRiyaz |
last post by:
I want to return record number with my query output.
I dont' want to use IDENTITY function and temp table for this purpose as I am dealing with very huge data.
any suggestions...
|
by: Bryan Parkoff |
last post by:
The C Compiler uses procedure function. It allows the programmers to
define global variables and global functions. They attempt to test using
debuging tools and often bugs are harder to find. If...
|
by: Alexander Pino |
last post by:
Hi,
does anyone know if, and how, I can return a record (set) from a stored
procedure/function?
What does the function have to do?
well at this moment I'm porting our product's database based...
|
by: SethM |
last post by:
I have a stored procedure that returns a record set. I want to
functionalize this so I can have multiple presentations of the same
record set. However, I can not get rs_event.open StoreProc to pass...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
