Hi,
I would like to know how to pass result set from a remote procedure call using DB link.
The proc1 in 1st instance calls proc2 in 2nd Instance using DBLink. The seond procedure has to ...
Hello experts,
I can't find the STNDRD20.OLB and CALENDAR.PLL any where !!
I tried the other names,extentions and different pathes but it's not there
please can anybody send it to my ema...
i want to change the default size of the database parameter like db_buffer_cache and shared_pool_size ,library_chace,hit_ratio to values that increase system performance by decreasing query re...
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...
Hey,
I have created a connection to oracle db in ASP session
now I'm trying to use savepoint and rollback.
The savepoint ("savepoint sp1") doesn't return an error but when I try to rollba...
Hi,
I am actually using Outlook for email interaction but I would like to be able to access my emails from oracle directly while working, without creating an email server. Anyone can help? T...
I haven't worked before with web services and oracle. Is it possible to invoke a web service from a pl/sql trigger of a table, sending data from that table? What should i do? I work with Oracl...
I have the following code in my FORM. I keep getting an ERROR 103 , pointing to the EXECUTE IMMEDIATE command each time i do a compile. I am using ORACLE 8.17 and FORMS 6i
THIS IS THE CODE:...
I am trying to use ERWin to create table for ORACLE, but I am not sure how to add comment for all column, I mean I hope all Logical column name is treated as comment for that column, does anyo...
Hi all
I am trying to run oracle stored procedure using jdbc OCI driver against Oracle 9.2.0.
I receive the following exception when trying to set a CLOB can someone help with it please.
...
I am having a problem with my form. I am able to query and insert but when I try to update or delete I receive the following error:
FRM-40735:LOCK-PROCEDURE trigger raised unhandled except...
Im using Access 2003 and I wanted to know if there is any way that I can create a view like in sql that will show a diagram of the tables and the keys. The will be of linked tables. Any 3rd ...
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...
I have a report that looks like this
Item Serial number Descr Date Type
all the fields except date come from o...
URGENT!!
Hi I am new to using Informatica
I am using the 7.1 version. Can anyone tell me how can I send a ".out" file as an email attachment using the email command task?
I have the ".out"...
I am trying to write sql statement to select / insert a distinct value (metername) and other info from a table where pointname is not distinct. metername = pointname
insert into METER(MET...
Hi I'm still trying to accomplish this feat. I've left off just trying to see if the row existed in the ST_Max table once I did my displays I found that I did have the fetched the same data bu...
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 ...
We have an application currently running Oracle Forms 6i. On the Client-Server application we use TEXT_IO and its procedures and functions to output data (from the screens and dB) to MSWord. ...
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?...
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...
Silly question but since I can't read the font I have to ask! Can anyone tell me how to change the font used for Comments in TOAD (v 7.6)?
How Do I use a cursor that return of a PL/SQL FUnction, into a SQL Stament? . I have Oracle 8i.
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,...
Dear All,
I have a field 'A1' is LONG datatype, how do i append the new value into that field when i execute UPDATE statement which will concatenate with my existing value in that field. ??? ...
