HI ALL, RECENTLY I JOINED THIS GROUP.I AM WORKING ON DISCOVERER.I WANT TO KNOW HOW CAN A LEXICAL PARAMETER CAN BE INCORPORATED IN DISCOVERER. COZ IN MOST OF...
Hi, Can anyone tell me how I can monitor the progress of a query that is being run if that is possible? Also, Thanks for all the help you had given me in...
Prescribed@...
Jun 2, 2005 3:09 pm
746
+ Interjection by listserv moderator: + If you wish to reply to this post, please make sure your response + goes directly to its author at bashir159@......
Yes, this works. However, as a general rule, I prefer not to use OUT parameters. Instead, if a stored procedure needs to return a value, I prefer to make it...
Hi, I wrote about this bit of code before. I finally got it working reasonably well. Unfortunately with the size of the database we have it still runs for...
Prescribed@...
Jun 22, 2005 12:17 am
750
First, anything that you can do in pure SQL, not PL/SQL, do it. It will usually perform better. That inner loop looks like it might be doable as INSERT ......
Hi John, Thanks for the advice and leads. I updated this query where it runs properly using the loops. To give an idea how long it runs. I ran it yesterday...
Prescribed@...
Jun 24, 2005 2:39 pm
752
Jim, We are currently in the process of integrating OID with our AD server. Take a look at the document "Integration with Microsoft Active Directory" under...
I have a forms question and hopefully someone can be of some assistance. I am working on a problem in one of the application's forms. There are two data...
Phillip
psmall57@...
Jun 29, 2005 2:42 pm
754
Phillip, You'll need to post the error message you receive when 'the curor will not leave direct time', plus some information about the relationship between...
Mark C. Stock
mcstock@...
Jun 29, 2005 3:19 pm
755
The form was already developed and the relationship between the two are: Direct time shows time charged to a specific project Indirect time show time charged...
Phillip
psmall57@...
Jun 29, 2005 6:12 pm
756
Hi, When I run the code below I get the following error on this statement: error: wrong number or types of arguments in call to ?||? on this statement: EXECUTE...
Prescribed@...
Jun 29, 2005 6:14 pm
757
COUNT can be COUNT(*) or COUNT (DISTINCT expression) but not COUNT(expression). ... going wrong on this. My eyes are starting to glaze over staring at it and...
actually, count() can count an expression (john, you may be thinking of something else?) SQL> select count(*), count(empno), count(decode(sal,0,null,sal)) as...
Mark C. Stock
mcstock@...
Jul 4, 2005 5:25 pm
759
Hi Mark, Thanks for getting back to me. I had the feeling that something was not right with that syntax. I have yet to put my finger on it. I have to dwell on...
Prescribed@...
Jul 6, 2005 4:30 pm
760
I have developed a form application built of two blocks on two different canvases. How do I set it up so that when double-clicked, the block will bring up the...
Phillip
psmall57@...
Jul 6, 2005 4:30 pm
761
Hello, My issue is dealing with forms and I want to have a page or tab listing of records in one tab. log#, disp, descr,...
Phillip
psmall57@...
Jul 6, 2005 4:30 pm
762
I tried to do this but in the drop down on the 'Synchronize with Item' option, the description for the other table is not one of the list. Are you referring...
Phillip
psmall57@...
Jul 6, 2005 7:42 pm
763
'mirror item' is a concept -- i think oracle may have used the term in its documentation at one point the idea of a 'mirror item' is that it is a 2nd occurence...
Mark C. Stock
mcstock@...
Jul 6, 2005 10:37 pm
764
I have an Oracle form that is a single block at the top of the page and at the bottom the 2nd block is a multi-record block. I went back and added a scrollbar...
in your w-m-d trigger go_block('< detail block name >'); execute_query; If you use the datablock wizard and set up your relationships correctly then you...
as far as i can recall (don't have a working forms installation right now) what you are describing is normal behavior -- the scroll bar will scroll the set of...
Mark C. Stock
mcstock@...
Jul 8, 2005 3:06 pm
767
Hi, Would anyone shed some light on this... 1) If 98% system availability of Oracle (11 modules) is considered industry standard for an SLA. If so, does IT...
Hi Phillip, You need two datablocks based upon the same table with a one to one relationship between them. use the tabular layout as the master block and the...
from just a quick look i think you can probably solve this without triggers -- assuming you have a multi-row block that displays a short single-line version of...
Mark C. Stock
mcstock@...
Jul 8, 2005 3:07 pm
770
block coordination should be done with a Relations object, not with EXECUTE_QUERY in a trigger navigation (in your WHEN-MOUSE-DOUBLECLICK) can be done with the...
Mark C. Stock
mcstock@...
Jul 8, 2005 3:07 pm
771
In Forms, how do you perform an insert into a table without getting the error 'Identifier table_name must be declared' ? I know there is a way to do inserts in...
Tarveen, I can not speak to Oracle 11. Ping of 120 milliseconds does not sound good. From a cable modem/ISDN/LAN connection 120 milliseconds is very bad. You...
Allen Shepard
ashepard@...
Jul 11, 2005 6:53 pm
773
Hi, Well I am still at it. Would someone out there please explain what I am doing wrong. I provided a substitution variable in a pl/sql block as part of a...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
