I've currently got an Oracle view that requires minimal maintenance each new month but I'm sure there is a way of coding it to be maintenance free if only I can find a way of calculating the p...
First of all, i have Oracle 10g installed in my PC, so i'm just connecting to the db locally for educational purposes. I always logon as SCOTT.
Ok, I have Oracle 10g already installed long ...
Dear experts,
I have a csv file that I am picking up from the server using a "sequential file" stage and am having some trouble with the table definition.
My data is stored using the dat...
I'm sure this is very simple but I just cant find any docs on this: How do I insert a trademark (TM) to registered (R) symbol into an oracle 8i table? I'm extracting data from another source...
I want to use an ADD_LIST_ELEMENT in a WHEN-NEW-FORM-INSTANCE that will list the current year as the 1st position in the list index. Next year in the second position and prior year in the 3rd,...
I do need to send an email directly fom Oracle Forms, just by pressing a but.
I already saw examples at Oracle Tech Net, but all of them use a package called UTML_STMP. I'm working on Oracle ...
Here we go again.
It has been determined to start over - bring the forms from 4.5 to 6i, and the database from 7.2.3 to 9.2.0.
Forms 6i will talk to my 9i database, however, when I try t...
I'm currently working on Oracle RAXINV invoice and making a number of modifications. The last one I need to make is to ensure that the invoice totals only print on the last page. The report as...
Currently I have a UNIX script that creates a SQL script
on the fly that unloads table data to a delimited ASCII
file via the sqlplus "spool" command. It works
flawlessly; however, we nee...
Hi
I can tnsping to an Oracle instance on a Server, using a local tnsnames.ora on my laptop. I can sqlplus to the instance, but when I try to login from Toad using the tnsnames.ora I'm gett...
i am using oracle forms, and i want to create a table and then drop it inside the pl/sql code in a 'when-button-pressed' trigger. but when i am writing the syntax, it gives a compilation error...
my database consists of different tables, i am trying to design a form as follow:
1. list item (this list item will be populated with player email addresses from player table)
player(p_i...
TOAD Sql Monitor for Oracle, latest version, throws exception "Error 2 installing monitor for the service process" during connection to any service. Turning on the logging does not help - n...
Hi all,
i would need a clue for the following:
I have to implement functions to check db-users for several DB`s.
So, i got some scripts to implement.
creating user.............. blablabla....
As I know, Oracle DB created with WE8ISO8859P1 character set cannot be converted directly to UTF8
Is there any possible way to convert (or migrate) data from WE8ISO8859P1 to UTF8 with minimal...
I am still unable to understand what is the purpose of above buit ins. what are the problems if I am not using them.
Please give some example as teacher.
Thanks
Hi,
i'm using Oracle Forms Builder 6i to connect to mySQL 3.23.49 via
Oracle Open Client Adapter for ODBC 6.0.5.35.0
Now I have a problem of controlling which form to commit if more tha...
Hi
I have this insert statment and I want to execute this statement to insert multiple rows but the values change. How do I do that.
insert into Test
(START_DT,END_DT,TIME_CD)
values(...
I have 3 questions.
In my application I am using ORACLE procedure with insert statement into table from select statement (INSERT INTO <TABLE_NAME>
(SELECT <huge select statement with UNIO...
How can I add a scrollbar to a window. I've been able to add scrollbars to data blocks. But I do have a form with 3 datablocks, and vertical space is not enough. Thanks indeed.
Julian
Hey Guys -- Any help would be appreciated....
Need to have Dynamic Creation of SQL Statement based on parameters passed into Stored Procedure. Return type of Function needs to be Ref Curso...
The package body should be able to be seen when you click on the "+" next to the package on procs tab of TOAD. But I can not see the package body for any packages with my ID on my PC, only spe...
How could I generate XML file from oracle table?
I get this error (in subject title) even though the file is right there in the directory. It's driving me nuts since I can't open up the library to modify some of the procedures that exist.
...
In TOAD's SQL Editor, can I force a query timeout or do a pause or break in a query I'm trying to run if it takes too long? I'm trying to stop queries that take too long without having to CTR...
