Developer
ORA-04062: timestamp of package "x" has been changed PDF Print E-mail
All in One - Developer
Written by Administrator   
Thursday, 01 October 2009 12:11

When a local piece of PL/SQL references a remote package, function, or procedure, the local PL/SQL engine needs to know if the reference(package, function, or procedure) is still valid, or, if the remote procedure has changed.

The locally compiled PL/SQL code is dependent on the remote code. This dependency is tracked by two models either TIMESTAMPS OR SIGNATURES in oracle.  

Check it :

SELECT name, value
FROM gv$parameter
WHERE name = 'remote_dependencies_mode';

 

REMOTE_DEPENDENCIES_MODE = Timestamp
The local PL/SQL block can only execute the remote PL/SQL block if the timestamp on the remote procedure matches the timestamp stored in the locally compiled PL/SQL block. If the timestamps do not match, the local PL/SQL must be recompiled.

REMOTE_DEPENCIES_MODE = Signature
The local PL/SQL block can still execute the remote PL/SQL block if its "signature" is the same, even if the timestamp has changed.

The term "signature" basically means the interface (procedure name, parameter types or modes) is the same, even if the underlying implementation has changed.

 
* You can alter the mode dynamically by using the DDL statements. For example, this example alters the dependency model for the current session:

Solution : ALTER SESSION SET REMOTE_DEPENDENCIES_MODE = {SIGNATURE | TIMESTAMP}

Thise example alters the dependency model systemwide after startup:
Solution : ALTER SYSTEM SET REMOTE_DEPENDENCIES_MODE = {SIGNATURE | TIMESTAMP}

 

Last Updated ( Thursday, 01 October 2009 16:20 )
 
to create search engine friendly (sef) url in joomla PDF Print E-mail
All in One - Developer
Written by Administrator   
Monday, 14 September 2009 16:02

to create search engine friendly (sef) url in joomla

JFilterOutput::stringURLSafe($var);

Last Updated ( Monday, 14 September 2009 16:04 )
 
joomla usefull codes PDF Print E-mail
All in One - Developer
Written by Administrator   
Wednesday, 29 July 2009 13:51
Giving any user group access to any component yourself! 

 

joomla 1.x.x by editing   /includes/gacl.class.php

You can do the same thing with Joomla 1.5 by editing the file:  libraries/joomla/user/authorization.php

 


 

Reach root !

JURI::root();

 

 

 

 

 

Last Updated ( Thursday, 15 October 2009 12:39 )
 
ASP.NET SqlMembershipProvider schema version error PDF Print E-mail
All in One - Developer
Written by Administrator   
Friday, 08 May 2009 17:32

ASP.NET SqlMembershipProvider schema version error

The ‘System.Web.Security.SqlMembershipProvider’ requires a database schema compatible with schema version ‘1′. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_reqsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.

  1. use aspnet_regsql(c:/windows/framework/.net 2.0 ) : remove and add
  2. Restart the web application
Last Updated ( Friday, 15 May 2009 20:07 )
 
Parser Error Message: Ambiguous match found. PDF Print E-mail
All in One - Developer
Written by Administrator   
Tuesday, 07 April 2009 09:54
do not declare any variables with the same name as any of your controls.
Last Updated ( Friday, 15 May 2009 20:13 )
 
« StartPrev12NextEnd »

Page 1 of 2