I agree with you Eyetry about your PS.
I would just add some tips I experienced :
There's often architectur solutions using multithread. A large input file could be cut into multiple small files and processed in parallel.
For your cuting map, use very simple typetree like one group containing a...
Bocaburger,
After search on other forums, the only response I needed was that it's impossible to get multiple rows in input cards from an Oracle stored proc... We are forced to write the select statement in the command line adapter or in the mdq file.
Oaiusr
Moreover, look at the message it returns :
java.lang.ArrayIndexOutOfBoundsException
at com.mercator.communication.WatchMapsSummary.getWatchMapInfo(WatchMapsSummary.java:133)
at com.mercator.communication.CommunicationLayer.getWatchMapInfo(CommunicationLayer.java:565)
at...
BocaBurger, I'v the same problem than Secrane with the same config. But it doesn't seem to be a network problem : Indeed, even if I run the command 'eventserver.sh -summary MyServerName' on the server itself, it takes 4-5 minutes to get the results, and it simply doesn't work with the -satusinfo...
That's what I tried to explain in my previous post with my exemple t_record : the typetree generated by the DID contains only one item instead of the tow items defined in the type t_record.
Is my explanation so full of mistakes ?
Ok, in fact I don't want the typetree corresponding to the stored proc parameters (usefull for an output card) but the typetree corresponding to the returned type as described, to get it in my input card.
To summary, I have to call a function or stored proc (with or without params) in an INPUT...
Thanks for your solution about the dbquery function.
But now, what's the method with an input card ?
For exemple, my oracle function or procedure returns the object TAB_RECORD below :
TYPE t_record is RECORD (
Id_cd varchar2,
Val_cd integer);
TYPE TAB_RECORD IS TABLE OF...
i do it with a new procedure where i do the same thing.
I print to the screen my result(whith dbms_output)
when i execute the procedure in Oracle client i have what i expect, but when i use mercator i have nothing. I can catch the result in my file.
Mercator Commande:
=DBQUERY("begin...
I used to select records from a Sybase database with Mercator 6.7.1. via a stored procedure in an output card :
PUT("FILE","%PATH_DATA%", Package(
DBQUERY("spu_my_sybase_stored_proc 'param1'", "%DB_SYBASE%
)
)
But we have now an Oracle database and I try to do as simple. It doesn't work ...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.