[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::sql_services

Title:	SQL/Services Forum
Notice:	kits(3) ft info(7) QAR access (8) SPR access (10)
Moderator:	SQLSRV::MAVRIS

Created:	Thu Oct 13 1988
Last Modified:	Fri Jun 06 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	2214
Total number of notes:	8586

2208.0. "ORA-1010 Invalid OCI-operation, multisession?" by 4107::PLINDGRE (A customer called...) Thu May 22 1997 13:12

    	RDB 7.0
    	SQL/Services 7.1
    	Oracle Forms 
    
    
    	Hi,
    
    a customer is trying to open a form from another form in Forms (I like
    that sentence ;-)) like this:
    
    	Open_Form(filename,ACTIVATE,SESSION,'Default'); 
    
    this will give the error ORA-1010 Invalid OCI-operation
    
    If he opens the form without creating a new session it works OK:
    
    	Open_Form(filename,ACTIVATE,NO_SESSION,'Default');
    
    I think I have found a restriction or limitation that could              
    apply to his problem. 
    
     From "Oracle SQL/Services 7.1 Release Notes 2.1 Restrictions and
           Limitations"      
    
        Multisession server is not supported:
     
    The Oracle7 server can support multiple sessions from multiple           
    client applications in one server process. SQL*Net for Rdb cannot        
    because of the locking differences between the two database
    products.    
    
    
    Could this restriction be the reason for the error 
    ORA-1010 Invalid OCI-operation?
    
    If yes, will this restriction be lifted in a future release?
    
    I know it's hard to answer but if someone knows WHEN  please give me a
    hint.
    
    
    	Regards
    
    	Peter

T.R	Title	User	Personal Name	Date	Lines
2208.1		AVMSV1::EKREISLE	Erich Kreisler	`Wed May 28 1997 07:28`	7
	Peter, I think the release notes reference to MTS (Multithreaded Server). Sorry can't help with the ORA error. erich
2208.2	You've got the right restriction	NOVA::GUZMAN	Ray Guzman -- Rdb engineering (SQL compiler/SQL*Net for Rdb)	`Wed May 28 1997 12:20`	19
	You've found the restriction that matches the problem. Unfortunately this is a difficult problem to solve, it has to do with Rdb's use of VMS locks and VMS locks affinity to processes. We've discussed implementing "transaction reusability" with SQL*Net for Rdb. That's the likely mechanism we'd use to mimic this feature. However there would still be restrictions, such as only one transaction active on a given session. Unfortunately, there are no plans to do this work in Rdb8. Possibly beyond Rdb8. With Oracle7 the feature does provide a performance increase in connect time (opening the new form), but I don't believe there's any gain of functionality. So your application should continue to work fine with Oracle7 if you don't use it. Sorry. - Ray
2208.3		4107::PLINDGRE	A customer called...	`Fri May 30 1997 05:24`	39
	Ray, I think your reply answer why SQL*Net for Rdb can't use the Multi Threaded Server option, correct? What my customer is looking for, on the client side, is to be be able to work in the same runforms and not have to load a new runforms. Loading a new runforms will cause creation of new windows and usage of more resources on the client. Open_Form(filename,ACTIVATE,SESSION,'Default'); If this command had worked, no new runforms DLL:s would have been loaded, the current loaded DLL would have been used but instead this will give the error ORA-1010 Invalid OCI-operation. If he opens the form without creating a new session it works OK: Open_Form(filename,ACTIVATE,NO_SESSION,'Default'); This command will cause the creation of a new executor process on the server side but it will also load new runforms DLL:s on the client side, this is not desireable. Why will not Open_Form(filename,ACTIVATE,SESSION,'Default'); just fire up a new excution process on the server side and let the client go on using the already loaded runforms DLL:s? This is maybe not the intention of the 'SESSION' parameter but it would let the client side use less recources. The customer would just like to open a new form from a another form without creating a new session (at least on the client side), is this possible? Regards Peter
2208.4	Try JCC	NOVA::GUZMAN	Ray Guzman -- Rdb engineering (SQL compiler/SQL*Net for Rdb)	`Fri May 30 1997 15:22`	39
	Sorry, what you're asking is really a Forms client question. I know a little about Forms, but not at this detail. You might try the JCC mailing list. They are sponsering a mailing list dedicated to using Developer2000 with Rdb. Some one there might have the answer. - Ray PS I subscribe, you get pretty good questions, very little noise. -------------------------------------------------------------- From: SMTP%"[email protected]" 15-NOV-1996 16:59:23.13 To: [email protected] CC: Subj: New Developer/2000 with Oracle Rdb mailing list As announced at Oracle Open World and the Rdb Symposium in San Francisco, JCC is sponsoring an additional mailing list for Developer/2000 specific issues. To subscribe, send an email to [email protected] with one line in the message as follows: subscribe rdbd2k Regards, Bill ------------------------------- Developer/2000 and Rdb are trademarks of Oracle Corporation. Oracle is a registered trademark of Oracle Corporation. JCC and jcc.com are trademarks of JCC Consulting, Inc.