Oracle stored procedures and functions

[dsandovich]

Hi,

I’m looking for example of calling Oracle stored procedures and functions from WinCC OA. How do you declare stored procedure? How do you pass parameters? Are Oracle bind variables supported?

Thanks,
Dmitry

[leoknipp]

Hello,

it is possible to used Oracle stored procedures and functions from WinCC OA.
We cannot give you a simple description for the usage, especially when OUT-parameters are used.
To be able to give you an answer we would need a more detailled description.


Please notice that the ETM Portal does not substitute the common PVSS/WinCC OA support.
If further information is needed please refer to the official support address for America: support.america.automation@siemens.com.
The responsible contact persons are Russell Barnes or Todd Malone, you could also contact them directly.

You can also have a look at our homepage to get detailled information for the WinCC OA support.
http://www.etm.at/index_e.asp?id=9&sb1= ... eite_id=24

Best Regards
Leopold Knipp
Senior Support Specialist

[dsandovich]

Thanks Leopold! It’s good to know that it is possible. I will contact Russell and Todd regarding details.

Regards,
Dmitry

[aorange]

It would be good if these questions could be answered on the portal so the rest of the community could benefit from this knowledge, it would also stop other people asking the same questions over and over which would in turn reduce the workload on your support team.

Just a suggestion

[vogler]

With the attached panel you can convert oracle packages to winccoa-script-functions. Start it, give a connection string, open the db-connection, choose a package, hit "generate".
A wrapper package $ in the oracle database and a winccoa-script-library will be generated - scripts/libs/ora_.ctl.
So, you can call/use oracle package functions like pvss functions, and also get values out of it!
There are some restrictions, for example not all datatypes can be handeld in/mapped to pvss... https://www.winccoa.com/fileadmin/image ... l2pvss.pnl