|
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 )
|
|
|
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 )
|
|
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 )
|
|
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. - use aspnet_regsql(c:/windows/framework/.net 2.0 ) : remove and add
- Restart the web application
|
|
Last Updated ( Friday, 15 May 2009 20:07 )
|
|
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 )
|
|
|
|
|
|
|
Page 1 of 2 |