Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Generated pl/sql code to consume web service.

thomasoApr 2 2013 — edited Apr 3 2013
This is same question from sql and pl/sql forum:
10944325

"Oracle 11g Express Edition (sadly, no Java).
Do you know of any tool similar to axis wsdl2java to generate pl/sql web service proxy code based on wsdl file only?
TIA
Thomas"

I've just read that Apex is able to consume a web service.
Does it generate set of pl/sql types and/or packages.
Any suggestion would be greatly appreciated.

Thank you
Thomas

Comments

SH_INT

What error are you getting? Are you sure the string you are trying to convert only contains numeric characters? The method you are trying will work so long as the string is just a representation of a number

1 person found this helpful
JanGLi

The value is 100 percent integer (2017). I have confirmed it by logging.

I even tried using this x = int('19') but getting an error.


Unfortunately i don't have python compiler at the moment. Getting just script fail error in log.

These are the classes i have added:

import string

import java.sql as sql

import java.lang as lang

Regards

JohnGoodwin
Answer

This works for me, no need to import java classes

fdmAPI.logDebug("Period Name=:%s" % fdmContext["PERIODNAME"])

fullYear = int("20" + fdmContext["PERIODNAME"][4:])

fdmAPI.logDebug("Full Year Name=:%s" % fullYear)

pastedImage_2.png

or

YearMinus1 = int("20" + fdmContext["PERIODNAME"][4:])-1

fdmAPI.logDebug("Year -1=:%s" % YearMinus1)

pastedImage_3.png

Cheers

John

Marked as Answer by JanGLi · Sep 27 2020
JanGLi

Thanks for help.

Regards

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 1 2013
Added on Apr 2 2013
#apex-discussions
2 comments
281 views