How to see who view your Facebook profile ?

JasperReports(iReport) run with PHP & Database Oracle

You can run iReport in your Oracle based PHP Application

1.      PHP Jasper Library (No required Jasper Report Server)

2.      PHP JAVA Bridge

3.      Web Service(Required Jasper Report Server)

 

Now I describe how to run iReports with your Oracle Based PHP Application using PHP Jasper Library

Click here for detail

Connect Oracle Database with Jasper iReport

Connect Oracle Database with Jasper iReport

Click here for Detail

Add Oracle JDBC JAR file to iReports

Add Oracle JDBC JAR file to iReports

How to use Parameter in where clause of oracle cursor

An example of Dynamic where clause in Oracle Cursor

declare
    v_deptnos  varchar2(100) ;
    v_rc       sys_refcursor;
    v_dept_name varchar2(200);
     str_sql varchar2(200);
    begin
       v_deptnos := '10,20';
       str_sql:=' or dept_name=''Accounting'';
       open l_rc for 'select dept_name from dept where deptno in (' || v_deptnos || ')'||str_sql;
     loop
       fetch v_rc into v_dept_name;
       exit when v_rc%notfound;
       dbms_output.put_line(v_dept_name);
    end loop;
      close v_rc;
  end;

Passing parameters to a procedure executed by Oracle DBMS_SCHEDULER

Passing parameters to a procedure executed by
Oracle DBMS_SCHEDULER

You should first create the job, then define the arguments, and then run it. When you create it, set the enabled attribute to false, so it won't run yet:

For Detail click here