Home » Developer & Programmer » Forms » Convert form 6i to 10g
Convert form 6i to 10g [message #207684] Wed, 06 December 2006 10:37 Go to next message
rgobatti
Messages: 7
Registered: December 2006
Location: SAKATA Seed Sudamerica
Junior Member
I have a program that was developed in Forms 6i.
Actually, this program:
- reads a table with a Blob column that contains a MS Word format Document.
- the document needs to be convert , then the program changes some variables that are wildcards.

In forms 6i I use a column with datatype Ole and the flowing procedure that read value from database:
PROCEDURE Pr_Abre_Contrato (pContrato   In  Contrato.Cont_Numero%Type,
                            pQuery      in Varchar2 )   Is

Workbook    OLE2.OBJ_TYPE; 
Application OLE2.OBJ_TYPE; 
MyDocuments ole2.obj_type;
Args        ole2.obj_type;
vWhere      Varchar2(200);

BEGIN
  If pQuery = 'S' Then
	  Go_Block('PRD_VARCONT_VALORES');
	  Clear_Block(No_Validate);
    vWhere  := ' CONT_NUMERO = '||pContrato;
    Set_Block_Property('PRD_VARCONT_VALORES',Default_Where,vWhere);
	  Execute_Query;
  End if;
  --	
  Forms_OLE.Exec_Verb('PRD_VARCONT_VALORES.MCO_MODELO',1);
  Workbook    := forms_ole.get_interface_pointer('PRD_VARCONT_VALORES.MCO_MODELO'); 
  Application := ole2.get_obj_property(workbook,'Application');
  OLE2.set_property(Application,'Visible','True');
  -- 
  OLE2.RELEASE_OBJ(workbook); 
  OLE2.RELEASE_OBJ(application);
  --
END;

To change the values I use:

To open the Document:
PROCEDURE Pr_Abre_Documento ( Workbook    In Out OLE2.OBJ_TYPE, 
                              Application In Out OLE2.OBJ_TYPE ) Is

BEGIN
  Forms_OLE.Exec_Verb('PRD_VARCONT_VALORES.MCO_MODELO',1);
  Workbook    := forms_ole.get_interface_pointer('PRD_VARCONT_VALORES.MCO_MODELO');
	  Application := ole2.get_obj_property(workbook,'Application');
    ole2.set_property(application,'visible','False');
END;

To replace the wildcards:
  hSelection  OLE2.OBJ_TYPE; 
  hFind       OLE2.OBJ_TYPE; 
  hArgs       OLE2.LIST_TYPE;
BEGIN
   hSelection := OLE2.GET_OBJ_PROPERTY(Application,'Selection');
   -- Now get the "Find" object from the selection
   hFind      := OLE2.GET_OBJ_PROPERTY(hSelection,'Find');
   -- Now we can call the execute method to do the search/replace
   hArgs := OLE2.CREATE_ARGLIST;
   OLE2.ADD_ARG(hArgs,TargetText);      /* FindText */
   OLE2.ADD_ARG(hArgs,TRUE);            /* MatchCase */
   OLE2.ADD_ARG(hArgs,TRUE);            /* MatchWholeWord */
   OLE2.ADD_ARG(hArgs,FALSE);           /* MatchWildCards */
   OLE2.ADD_ARG(hArgs,FALSE);           /* MatchSoundsLike */
   OLE2.ADD_ARG(hArgs,FALSE);           /* MatchAllWordForms */
   OLE2.ADD_ARG(hArgs,TRUE);            /* Forward */
   OLE2.ADD_ARG(hArgs,0);               /* Wrap wdFindAsk=2, wbFindContinue=1,  wdFindStop=0 */
   OLE2.ADD_ARG(hArgs,FALSE);           /* Format */
   OLE2.ADD_ARG(hArgs,ReplaceWithText); /* ReplaceWith */
   OLE2.ADD_ARG(hArgs,2);               /* Replace wdReplaceAll=2, wdReplaceOne=1, wbReplaceNone=0 */
   OLE2.INVOKE(hFind,'Execute',hArgs); 
   OLE2.DESTROY_ARGLIST(hArgs);
   -- Clean Up
   OLE2.RELEASE_OBJ(hFind); 
   OLE2.RELEASE_OBJ(hSelection); 
   --OLE2.RELEASE_OBJ(Application);
END;

Now, I need to convert this program to forms10g. I opened the TAR in metalink and the Support said that
exec_verb can not be used and it doesn't have another one to replace.

Does anybody have an idea?

[Updated on: Wed, 06 December 2006 18:14] by Moderator

Report message to a moderator

Re: Convert form 6i to 10g [message #207747 is a reply to message #207684] Wed, 06 December 2006 18:53 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you looked at http://forums.oracle.com/forums/thread.jspa?messageID=424875 and http://forums.oracle.com/forums/thread.jspa?messageID=587055&#587055

Have you tried using 'ole2' as detailed in Note: 190252.1?

David

[Updated on: Wed, 06 December 2006 19:30]

Report message to a moderator

Re: Convert form 6i to 10g [message #208648 is a reply to message #207684] Mon, 11 December 2006 13:27 Go to previous messageGo to next message
rgobatti
Messages: 7
Registered: December 2006
Location: SAKATA Seed Sudamerica
Junior Member
David,

I Tried use the solution, but not working, neither compile
using the solution shown. Do I need to configure some other thing?
The bigger different between my solution and the shown, that I read word document from table.
The document 190252.1 read a word file from local drive.

Thanks,
Re: Convert form 6i to 10g [message #208681 is a reply to message #208648] Mon, 11 December 2006 21:30 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What is the compile error that you are receiving?

David
Re: Convert form 6i to 10g [message #208813 is a reply to message #208681] Tue, 12 December 2006 05:12 Go to previous messageGo to next message
rgobatti
Messages: 7
Registered: December 2006
Location: SAKATA Seed Sudamerica
Junior Member
David,

I don't get access the site www.tigralen.sbp.ru to load the file
OLEXTRA indicate in: http://forums.oracle.com/forums/thread.jspa?forumID=82&threadID=198798. Do you know where Can I this library ?

The error is because I don't have this library.

Thanks,
Re: Convert form 6i to 10g [message #208991 is a reply to message #208813] Tue, 12 December 2006 21:13 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
For the second time, what is the text of the compiler error?

What are you expecting to get from www.tigralen.sbp.ru ?

What library don't you have?

For goodness sake, tell us what you SEE not what you think.

David
Re: Convert form 6i to 10g [message #209103 is a reply to message #208991] Wed, 13 December 2006 05:54 Go to previous messageGo to next message
rgobatti
Messages: 7
Registered: December 2006
Location: SAKATA Seed Sudamerica
Junior Member
David,

I got the library with a member this forum.
I have another doubt now: I receive a olextra.pll e olextra.dll and a form test olextra.fmb. When I compile this program shown the error Activate_Server not exists. I don't know how I associate a .ddl with forms.

Thanks your help.
Re: Convert form 6i to 10g [message #209238 is a reply to message #209103] Wed, 13 December 2006 22:59 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you got ANY form to compile and run under 10g? If you have got a form to run then I assume that you have placed the Form that work's directory in the FORMS_PATH in the registry. Put the DLL into a directory which is in your Windows PATH - probably c:\windows\system32.

Open the pll file in form builder and make sure that it will compile. Save it. Tell us whether one of the procedures in it is called 'Activate_Server'. Don't worry about generating it. A plx file is not helpful in the development environment.

I believe that the pll may be referred to in the fmb via a fixed directory name. Open the form in Forms builder, delete the attached pll, attach the pll file and select the non-default option to remove the directory name.

Do a Ctrl-Shft-K (Compile All), then Ctrl-T (Generate), and then save it.

Run the form and see what happens.

David
Re: Convert form 6i to 10g [message #209318 is a reply to message #209238] Thu, 14 December 2006 04:47 Go to previous messageGo to next message
rgobatti
Messages: 7
Registered: December 2006
Location: SAKATA Seed Sudamerica
Junior Member
David,

I discover what is happening. Activate_Server is a built-in that working in forms 6i. My problem is I'm using forms10g, where this built-in does not valid.
Will be that exist something to form10g ?
Can I construt a built-in to 10g ? How ?
Re: Convert form 6i to 10g [message #209775 is a reply to message #209318] Sun, 17 December 2006 20:04 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I googled 'forms_ole activate_server convert OR migrate' and found "Oracle9i Forms Developer and Forms Services, Migrating Forms Applications from Forms6i, Release 9.0.2 Patch 1 for Windows and UNIX, October 2002, Part No. B10171-01" which contains
Other Obsolete Built-ins
The following built-ins have been removed. Code that contains these built-ins will not compile and should be recoded, although exceptions are mentioned in the following table.

(FORMS_OLE.) ACTIVATE_SERVER
(FORMS_OLE.)CLOSE_SERVER
(FORMS_OLE.)EXEC_VERB
(FORMS_OLE.)FIND_OLE_VERB
(FORMS_OLE.)GET_INTERFACE_POINTER
(FORMS_OLE.)GET_VERB_COUNT
(FORMS_OLE.)GET_VERB_NAME
(FORMS_OLE.)INITIALIZE_CONTAINER
(FORMS_OLE.)SERVER_ACTIVE

No migration path or replacement
functionality.

It looks as though you will have to use ole2 or ora_ffi to satisfy your requirements.

David
Re: Convert form 6i to 10g [message #341469 is a reply to message #207684] Mon, 18 August 2008 23:47 Go to previous messageGo to next message
asgharian
Messages: 6
Registered: August 2008
Junior Member
Hi

I don't get access the site www.tigralen.sbp.ru to load the file
OLEXTRA . Do you know where Can I this library ?


Thanks,
Re: Convert form 6i to 10g [message #341490 is a reply to message #341469] Tue, 19 August 2008 01:37 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'OLEXTRA'.

David
Re: Convert form 6i to 10g [message #341500 is a reply to message #341490] Tue, 19 August 2008 01:58 Go to previous messageGo to next message
asgharian
Messages: 6
Registered: August 2008
Junior Member
Hi

I don't get access the reference in this fourm for example this site www.orablogs.com/forms/archives/olextra.fmb . Do you know where Can I this library ?


Thanks,
Re: Convert form 6i to 10g [message #341501 is a reply to message #341500] Tue, 19 August 2008 02:16 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have a look at http://forums.oracle.com/forums/thread.jspa?forumID=82&threadID=198798

David
Re: Convert form 6i to 10g [message #341504 is a reply to message #341501] Tue, 19 August 2008 02:22 Go to previous messageGo to next message
asgharian
Messages: 6
Registered: August 2008
Junior Member
hi

this webpage http://www.tigralen.spb.ru/download/olextra/olextra.zip.
cannot display for me if you know where Can I this library please help me .

thanks
Re: Convert form 6i to 10g [message #341509 is a reply to message #341504] Tue, 19 August 2008 02:47 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Did you read the thread? The way I read it you will have to change your code.

David
Re: Convert form 6i to 10g [message #341526 is a reply to message #341509] Tue, 19 August 2008 04:00 Go to previous messageGo to next message
asgharian
Messages: 6
Registered: August 2008
Junior Member
hi

I Want To Save Ole To File In Form6i, I Think With OLEXTRA Lib
I Can , So Search This But Can' t Found in Fourm Reference
if you know where Can I Found this library please help me .

thanks
Re: Convert form 6i to 10g [message #341576 is a reply to message #341526] Tue, 19 August 2008 06:45 Go to previous messageGo to next message
rgobatti
Messages: 7
Registered: December 2006
Location: SAKATA Seed Sudamerica
Junior Member
Please, send me your e-mail that I send the library for you
I didn't get to attach the file here.
Re: Convert form 6i to 10g [message #341578 is a reply to message #341576] Tue, 19 August 2008 07:03 Go to previous messageGo to next message
asgharian
Messages: 6
Registered: August 2008
Junior Member
hi

My Email Address : Asgharian@mapna.com

Very Thank
Re: Convert form 6i to 10g [message #341660 is a reply to message #341578] Tue, 19 August 2008 17:29 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
In future, I suggest you send information like your email address via Private Messaging.

David
Re: Convert form 6i to 10g [message #342098 is a reply to message #209238] Thu, 21 August 2008 05:57 Go to previous messageGo to next message
subhankar.maiti
Messages: 4
Registered: August 2008
Junior Member
Hello,

I have also faced the same problem, please send me the OLEXTRA library and test.fmb form.


Thanks,

Subhankar

[Updated on: Thu, 21 August 2008 06:00]

Report message to a moderator

Re: Convert form 6i to 10g [message #342913 is a reply to message #209238] Mon, 25 August 2008 08:37 Go to previous messageGo to next message
subhankar.maiti
Messages: 4
Registered: August 2008
Junior Member
Hi,

I got the library and the demo form with a member of this forum. But there is no procedure in it called 'Activate_Server', please help me.


Thanks,

Subhankar
Re: Convert form 6i to 10g [message #343027 is a reply to message #207684] Mon, 25 August 2008 23:34 Go to previous messageGo to next message
asgharian
Messages: 6
Registered: August 2008
Junior Member
Hi

I still have not OLEXTRA Lib Please Help Me !

Thanks
Re: Convert form 6i to 10g [message #343216 is a reply to message #343027] Tue, 26 August 2008 11:53 Go to previous messageGo to next message
rgobatti
Messages: 7
Registered: December 2006
Location: SAKATA Seed Sudamerica
Junior Member
Inside the file olextra.pll you had the function Activate_Server but it's commented on.

See
Re: Convert form 6i to 10g [message #346401 is a reply to message #343216] Mon, 08 September 2008 07:55 Go to previous messageGo to next message
subhankar.maiti
Messages: 4
Registered: August 2008
Junior Member
I can not find the function Activate_Server inside the library olextra.pll. please send me the library file.

Thanks,

Subhankar
Re: Convert form 6i to 10g [message #349152 is a reply to message #343216] Fri, 19 September 2008 02:18 Go to previous messageGo to next message
subhankar.maiti
Messages: 4
Registered: August 2008
Junior Member
There is no procedure called 'Activate_Server'. please send me the olextra.pll file once again.

Thanks,

Subhankar
Re: Convert form 6i to 10g [message #442937 is a reply to message #207684] Thu, 11 February 2010 08:52 Go to previous message
waqaslodhi
Messages: 1
Registered: February 2010
Junior Member
Pl send me olextra libray on waqaslodhi@gmail.com

Thanks
Waqas
Previous Topic: beginner help (merged by CM)
Next Topic: FRM-40737 what i can do .. ??
Goto Forum:
  


Current Time: Sat Oct 01 09:14:48 CDT 2016

Total time taken to generate the page: 0.09143 seconds