I have two forms: FORM1 does a call_form to FORM2.
What i want to do is to pass a value called V1 that was calculated in FORM1 over to FORM2.
HOW DO I PASS VALUES BETWEEN FORMS?
Hi
I have this code:
Resultset rs1;
rs1 = stmt.executeQuery(" select text from user_views where view_name = 'my_view');
now the text column is a Long datatype in Oracle
getStri...
I am developing a student enrolment system. There is a master table for basic info. The table name is STUDENT. Then I have a table SDETAIL(subject,timing,credits, ... etc) for each individual ...
Hi
While using SQL plus to perform a simple query:
Select * from country
I received this error "Table or View does not exist".
But when I change the query to
Select * from "Country"
...
I have a table that has over 1 million entries in it. Teh table needs to be emptied out and the contents refreshed.
Which one will acomplish this faster, the use of the DELETE or TRUNCATE?
Hi,
I need some info about Oracle Package Variables..can
anyone recommend a good site.
Let me explain my problem a bit...
I am calling one procedure in an Oracle Package which is using Pac...
Hello,
could someone help me to create global record group from form's names?
I am not lucky in adding non database items in record group :(
s.
Is it possible to transfer a pl/sql collection (table) as a parameter from Forms to Reports ? (i'm working with developer 6i, database version 9) I don't want to use ref cursors because I have...
Hello,
Trying to run the attached Oracle query in sql*plus worksheet yields the following error:
ORA-00979: not a GROUP BY expression
The analagous query works in sql server.
An...
Does anyone know of/where I can find such a utility? I would need the documentation as well.
I have a separate form with a parameter. This parameter gets populated by the calling form with a string which is basically the FROM and WHERE clause of a select statement I'm dynamically bui...
in our organization we are using oracle database and a software for attandance system i want to configure it on linux machine. is it possible if it is possible kindly suggest me what we need t...
I have a small question on recursive sub programs in Oracle. I have a one procedure xx_FIRST with one parameter. In this procedure at circumstances I need to call the same procedure with diffe...
I am installing D2K (forms-6, report-3 (of oracle7.3)) on Win-XP Home Edition. When I click 'setup.exe' it gives 'not a vliad win32 application'.What should I do to overcome from this problem?...
Environment : Oracle Application 11i/Forms 6i sp5
I am now going to submit request/request set in form.
And I have some questions about it:
(1)Which package/library can I use to submit ...
I am using Oracle Report Builder 6.0.8.20.1
The report that I am working on uses two sections in the layout model (Main and trailer sections).
my users have requested that a user paramet...
I modified the Sprepsql.sql from Statspack to only produce the following output:
Enter the Begin SnapShot ID#: 32
Enter the End SnapShot ID#: 33
Enter the Hash Value from Statspack repo...
I am using Oracle 8.1.5 and attempting to build a db in Win 2000 using svrmgr.
I have installed Oracle, ceated a "Temp" db as part of the installation. I then deleted the "Temp" db using D...
I have a large quantity of PDF files that need to be accessed in a web environment. My first thought was to FTP them over to the unix box and within the database create a bfile table for them...
Hello all,
How do I return the list item index of the item that has been selected in a TLIST?
By just refering to :BLK_NAME.LST_NAME only returns the value of the selected item, not inde...
Can someone please refer me to a site (except asktom) where I found an electronic version of the book above or some material written by Kyte. His site offer only one chapter to download.
Or...
Hi guys
i am using free version of toad 6. I want to logon using sys as sysdba in order to use explain plan feature of toad.
Toad has following login screen which asks for the fields...
We are very new to Oracle forms. We have several tabbed forms. We're trying to present only certain tabs on each one, based on a query of a user security table. We've gotten as far as to eff...
I would like to extract the performance graphs in the Oracle Enterprise manager, and the OID web interface to flat files to display them on an external system, I would be pleased to know how f...
i'm trying to run an accent insensitive search on oracle 8.1.7
what do i need to do? i can find any documentation about such a thing on the web.
can 8.1.7 do accent insensitive searches?...
