FaqHow do you pronounce Amalegeni ?Stress the leg: ama-LEG-eni What is the meaning of the word Amalegeni ?Rubber. It's strips of old rubber tube of the car or truck variety. What are the different delimiters ?
Refcursors returned for PL-SQLWhen using the square bracket delimiters for PL-SQL code, any results returned by a function are assumed to be a ref-cursors ! If you want to select a single varchar for example, then better use the SQL delimiter, and write your call as follows:
The above example is valid for the Oracle database, for Postgresql drop the 'from dual'. Is there a difference between code generated for different databasesFor plain JDBC code generation, there is no difference, it's only the bits for PL-SQL that are different, because Oracle uses a different Type for returning pl-sql resultsets via JDBC, compared to Postgresql. That's why you need to specify the 'target' database when defining PL-SQL. How can you invoke Amalegeni using Ant ?Add the following to your build.xml file:
|