Search results for query: *

Hello, I'd like to know if someone knows about a program that add a button to outlook to allow the user to save a mail (or group of mail) to a database (typically oracle). It would be good if the tools opens a window to ask for a reference so that we know where to save this in the database. If...

Hi, Sem gave me a good answer when I asked for this on this forum. He gave me the link to Ask Tom. I wrote a richer version which I give to you. How it works: You call a function HOST with the text of the command to run in shell. This command is sent in a PIPE by Oracle. It is received by a...

Hi, I need to run an host command (EXP ...) from my PL SQL code. I heard about doing this through a java function. Does someone knows about this? Thanks.

Hi, I can't access oracle 7.3.4 instances from enterprise manager 9.2. The error is that I need more privileges than the user has. I created the role SELECT_CATALOG_ROLE in SYS, but that changes nothing to the problem. Does someone has a way to make it work? This is VERY urgent. Thanks...

Hi, (Note that I did not find an answer to this question in this forum.) I have this code in a package: PROCEDURE TEST(C CURSOR!!!, others param..) IS aa varchar2(100); BEGIN aa := C.value; END; PROCEDURE MAIN(...) IS BEGIN FOR C IN (SELECT value FROM table WHERE...) LOOP...

Hi, Does any one of you know how to copy, delete, create files in OS filesystem directly from oracle? UTL_FILE is no help for my use... Thanks, Christian

Hello, Because I'am working on a project where it is needed to duplicate non adjacent records, I developped a COPY_RECORD procedure: The needed things: A block containing a 'source' record you want to duplicate and a dest record IN THE SAME BLOCK to want to populate with the data of the...

Hi Guys, I work on an old Forms 6 version. I just got the metalink access and I see that Developper 6.0 is know replaced by 6i. Here are my questions: Are them the same products ? How do I pass from 6.0 to 6i ? Did someone of you migrated apps till the last 6i version ? Was there problems...

Hi, I am doing a form to automatically send mails (I use forms because I do Excel docs using OLE to link them to the mails...). It works but the From and ReplyTo properties. My code is: FUNCTION Send_a_mail( Recp IN varchar2, CopyTo IN varchar2, CopyHidden IN varchar2, MailFrom IN varchar2...

Please help!!! I have a very slow query generated by forms, but when I use and optimizer hint in SQL*Plus, it is much faster. This is good. But when I put this optimizer in the field optimizer hint of the block property called optimizer hint, forms does not put it in the query. I use forms...

Hi everybody, I have a problem of locked data. A user tries to update a table with have a trigger updating another table on which the user is sometime on modification. So it hangs for a long long time. My questions are: 1 - Is there a way to get a fast error message telling the user that a...

I wrote this function from a source which was shared on internet, so I share it too... -- Code is self explaining... -- dialog is 1: mail is displayed and user can modify it -- dialog != 1: mail is not displayed, it is sent -- Text can not be HTML, only basic text FUNCTION Send_a_mail( Recp...

Hello, I have megabytes of messages like this one in my sqlnet.log file. Does anyone knows what causes this and how to solve? Fatal NI connect error 12203, connecting to...

Hi all, I experience a lot of dumps in forms execution (i.e: the form crashes). The dump file contains unusable data since the crash seems occur anywere in the forms. Does someone had the same problem? How to find where is the problem? Thanks a lot. Christian

Hi all, I experience a lot of dumps in forms execution (i.e: the form crashes). The dump file contains unusable data since the crash seems occur anywere in the forms. Does someone had the same problem? How to find where is the problem? Thanks a lot. Christian

I can open, modify an excel sheet from forms 6i under XP, but when I want to save it, I use : OLE2.INVOKE(workbooks, 'Save'); (which I am not sur is the good command) Does any one know how to save an excel sheet WITHOUT having to answer a question? Thanks

I do this command: COPY FROM xx/xx@RPNEW TO xx/xx@RP3 REPLACE GENRE_TREE_NEW USING (SELECT * FROM GENRE_TREE) I get these messages: Taille tableau extrait/lié est 15. (taille du tableau est 15) Sera validé après opération. (COPYCOMMIT = 0) Taille maximum (LONG) est 80. (longueur est 80)...

Hello, does someone know what to do to be able to save my forms into the database when using the forms menu File->Save As->Database... I get a -942 error which I think means it doesn't find it's tables. Thank you.

Hello, does someone heard about a way to automatically maintain an history of code modifications in CVS (or other like sourcesafe...) ? It's about end the mess of having to manually set the packages in CVS... I think about triggers on modify packages? Thank you.

Hi all, How to get a text item content including the ending spaces? Eg: the user types 'Hello ' (with 3 spaces) When I use length(:block.item), I get 5 and not 8. I tried all the :system.cursor_value... around and found nothing. So does someone knows how to get the full content of the...