2012年8月31日 星期五

Oracle: Run stored procedure


SET serveroutput on;
variable f NUMBER;
execute fasspha.FASSPHA_FINANCIAL_TAG.getEquityRollBack('3140000', 2010, '14.856', '0','PROGRAM','1000126', :f);
print :f;

PwoerShell is not digitally signed. The script will not execute on the system. Please see "get-help about_signing" for more details

In PowerShell, use Set-ExecutionPolicy to change the status
  • Restricted – No scripts can be run. Windows PowerShell can be used only in interactive mode.
  • AllSigned – Only scripts signed by a trusted publisher can be run.
  • RemoteSigned – Downloaded scripts must be signed by a trusted publisher before they can be run.
  • Unrestricted – No restrictions; all Windows PowerShell scripts can be run.
Example: Set-ExecutionPolicy RemoteSigned