Hello,
Is there any way to create BND files for SQL procedures? I know that the PRECOMPILE command can be used to generate BND files from source files containing embedded SQL statements. But what can i use for SQL scripts containing SQL PL procedures?
Thank you,
P
Hi,
I have a performance problem. A java client is used to insert several hundred thousands of entities into an Oracle9i database. An entity is composed of data from several tables. During the insert checks are made. Because of the checks the inserts are very slow after 100k. I have found where...
Hello,
I have an abstract class Base which implements interface If1.
Classes D1, D2 and D3 are derived from Base.
Right now, the "common" methods from If1 are implemented only in the Base class and the specialized methods are implemented directly in the derived classes. The...
Thanks, but create table automatically commits if I'm correct ( i'm not sure about temp tables).
One solution that i found was to use a cursor and leave it open (close it and deallocate in the calling stored procedure ).
Thanks again,
Bobby
Hi,
I need to get and be able to process the result set returned by a stored procedure in the calling stored procedure. How can I do that?
I don't want/am not allowed to use table valued functions.
Thanks,
Bobby
The report wasn't formatted correctly. This is how it should appear. Each fee under the corresponding diag. Same for the cursor.
Name Date Reason Code Billing Total
---------------------------------------------------------------
John Doe 01/01/2000 yyy nnn...
Hi,
I am sorry i wasn't quite clear so i will try to expose the whole problem.
I have a table like the one shown below; this table represents a single day and is the result of a join. Diag values can vary greatly from one day to another, for example A B C D and the next day B C F R T Z Y W...
Many thanks guys,
Indeed the cross-tab seems to solve my problem though there is another question i want to ask you.
This is a daily report and there are days when i do not know what values i will use. There is no fixed limit and could be quite a lot of values in a single day.
For example A B C...
Hello,
I have a table like this:
patid diag fee
----------------------
1 A 10
2 B 15
2 A 10
3 C 20
3 A 10
3 D 25
4 B 15
And i want my report to look like this:
ID Diag...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.