Createing web service interface from a wsdl

C:\Program Files\Microsoft Visual Studio 9.0\VC>wsdl /si c:\test\wsdl\bizprocessadmin.wsdl /out:c:\test\wsdl\ (the c# interface file will generated under this folder)

Add comment September 2nd, 2010

checking constraints on the columns of a oracle table

SELECT b.table_name, b.column_name
FROM SYS.ALL_CONSTRAINTS S , SYS.ALL_CONS_COLUMNS B
WHERE S.OWNER=TEST’ AND S.TABLE_NAME=’ACCOUNT’
 AND S.CONSTRAINT_NAME=B.CONSTRAINT_NAME

Add comment August 30th, 2010

what is the oracle equivalent for datediff in sql sever?

Floor(sysdate - to_date(’100825′,’yymmdd’))=0

Add comment August 30th, 2010

VMware admin

ou can decide to remove this software from your system at any time by invoking the following command: “rpm -e VMware-server”. instead of puting in the whole package name, just put in VMware-server  in order to remove the vm ware from your box.

Add comment August 27th, 2010

Business objects how to call web service to create a report instance

available business object web service can be access

http://biportalsite.com/dswsbobje/services/listServices

use the session service to establish a connection

http://biportalsite.com/dswsbobje/services/Session?wsdl 

use the biplatform to schedule a run (scheduel for run now)

http://biportalsite.com/dswsbobje/services/BIPlatform?wsdl

 

Add comment August 25th, 2010

Bat command how to do number compare

  IF %ERRORLEVEL% gtr 0 GOTO ExitError

  ECHO “Load data into %table% complete successfully”

Add comment August 25th, 2010

Oracle 10g how to change default date time display

 

change system wide

alter system set NLS_DATE_FORMAT=’DD-Mon-YYYY HH24:MI:SS’

change session 

alter session set NLS_DATE_FORMAT=’DD-Mon-YYYY HH24:MI:SS’

Add comment August 25th, 2010

Composing Bo link to the last instance of the report

Find the report object, right click and choose properties

>> got the document id

>>compose link as

http://mybosite.com/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AYJLxL96IBlPvrwhKja0G4c&sInstance=Last

 

Add comment August 24th, 2010

oracle 10g SQL loader exit code

Result Exit Code
All rows loaded successfully
EX_SUCC

All or some rows rejected
EX_WARN

All or some rows discarded
EX_WARN

Discontinued load
EX_WARN

Command-line or syntax errors
EX_FAIL

Oracle errors nonrecoverable for SQL*Loader
EX_FAIL

Operating system errors (such as file open/close and malloc)
EX_FTL

 

For UNIX, the exit codes are as follows:

EX_SUCC 0
EX_FAIL 1
EX_WARN 2
EX_FTL 3
For Windows NT, the exit codes are as follows:

EX_SUCC 0
EX_WARN 2
EX_FAIL 3
EX_FTL 4

Add comment August 20th, 2010

Oracle how to print a ref cursor content out?

create or replace package pkgTestCurPrint as
type typeCur is ref cursor;
procedure testcurP(output out typeCur);
end;
/

create or replace package body pkgTestCurPrint as
procedure testcurP(output out typeCur) is
begin
open output for select * from account;
end;
end;
/
var refCur refcursor
exec pkgTestCurPrint.testcurP(:refCur)
spool c:\temp\printstaff.dat
print refCur
spool off

Add comment August 18th, 2010

Previous Posts


Categories

Links

Feeds

Admin