Recent content by ceccina

That's ok. Thanks.

Thanks, that works! Another question: if RETRIEVE_INGRESSO is defined in another schema, how can I call that? if I simply write : SELECT SIPIMENSETEST.RETRIEVE_INGRESSO(inAnno,inServizio) into v_hold_Ingresso from dual; I have error: PLS-00201: identifier 'SIPIMENSETEST.RETRIEVE_INGRESSO' must...

Of course the correct syntax is: > SELECT RETRIEVE_SCUOLA(78052,2009,2) from dual; but it never ends! Looking the session, the query seems 'freezing' on the RETRIEVE_INGRESSO call.

CREATE OR REPLACE FUNCTION SIPI.RETRIEVE_INGRESSO(inAnno number,inServizio number) RETURN NUMBER IS vIngresso number; BEGIN SELECT id_ingresso into vIngresso FROM SETUP i WHERE I.ID_SERVIZIO=inServizio AND to_char(I.DT_INIZIO,'yyyy') = inAnno; RETURN(vIngresso)...

Hi, I have Oracle 8.1.7 I defined a store procedure 'A' which call another stored procedure 'B'. If I execute procedure B and I substitute the result to the call of procedure 'B' inside 'A', it works. But if I call 'A' leaving the call to 'B', it never ends. It locks the table and I cannot kill...

Yes, thanks a lot.

CREATE OR REPLACE FUNCTION MESSITEST."PROT_GEN" (name_seq IN VARCHAR2) RETURN NUMBER IS aNumber NUMBER ; BEGIN SELECT name_seq.NEXTVAL into aNumber from dual; RETURN aNumber; EXCEPTION WHEN OTHERS THEN RETURN null; END PROT_GEN; / That gives me an error on select...

How can I extract hh:mi from a date filed (dd/mm/yyyy hh:mi) and making time differences?

My database is Oracle 8.1.7 I am not a programmer, but I think this is the part of code which requires data. There are several other files imported and perhaps <!--#include virtual="/_Dev/Objects/Miscellaneous/DateSelector.asp"--> is interesting for you, but it is too long. <div...

Hi, I have an application written in ASP. I cannot insert the date 31 march 2002. Days stop at 30 march 2002. Other years are ok.

I want that Notes ask me my password opening a local database even if I've just authenticated myself on Notes client. How can I rich that? Thanks

Is there any way to export a report in Excel (or CSV) format using Crystal Report X for Java API's? Only PDF and RTF works?

Now it works after having installed KDE interface.

Hi, I have a J2EE application which uses Crystal Report for JBuilder 2005 to display reports developed with Crystal Report 10. I put that on a Tomcat 5.5.9 server installed on a SLES 9 machine (Kernel version 2.6.5-7.97-smp). When I call the jsp page wich calls the viewer, I get this exception...

Hoe can I disable autolink option in Database expert in CR9?