Pl SQl Web Kit

[GoogleCodeExporter]

What version of the product are you using? On what operating system?
Oracle 10g
Pl Sql Web Kit

Hello

I'd like use this plugin with PL SQL Web, but i didnt get work.

Do you have some example?

Thank you

Vinicius
vadelagu@gmail.com

Original issue reported on code.google.com by vadel...@gmail.com on 8 Apr 2010 at 5:40

[GoogleCodeExporter]

The code to use the integration kit in a plain PL/SQL Web Toolkit application 
is the 
same as for an Apex application. See the example under "Basic example" on the 
project 
page.

Please be more specific as to what did not work (what did you do? did you get 
any error 
messages? etc.)

Original comment by thehunge...@gmail.com on 10 Apr 2010 at 12:09

• Added labels: Type-Other
• Removed labels: Type-Defect

[GoogleCodeExporter]

Hello

I get render the grid but dont show the data.

Original comment by vadel...@gmail.com on 10 Apr 2010 at 12:11

[GoogleCodeExporter]

Can you try to view the page in Firefox, and turn on the Error Console to see 
if there 
are any Javascript errors?

Original comment by thehunge...@gmail.com on 10 Apr 2010 at 12:54

[GoogleCodeExporter]

I got :)

Do you have any example to add new row...opening new form?

Original comment by vadel...@gmail.com on 10 Apr 2010 at 12:57

[GoogleCodeExporter]

To add a new row, just click the "Add row" link at the bottom of the grid. 
Depending on 
your configuration of the grid, when you save the row this will either generate 
an 
INSERT statement, or call your own PL/SQL function that will handle the insert 
and 
return the ID of the new row.

Original comment by thehunge...@gmail.com on 10 Apr 2010 at 1:06

[GoogleCodeExporter]

when i click the "add row" nothing happened. 

I need set any configuration to work this?

Original comment by vadel...@gmail.com on 10 Apr 2010 at 1:22

[GoogleCodeExporter]

Clicking the "Add row" link is supposed to add a new row to the (client-side) 
grid. You 
need to set the jqgrid.read_only column in the configuration table to "false" 
(or 
jqgrid_pkg.g_false) in order for the links to work. The grid is read-only by 
default.

Original comment by thehunge...@gmail.com on 10 Apr 2010 at 1:28

[GoogleCodeExporter]

Just trying to install it and I got an error loading the json_util_pkg.pks
launched by the install.sql.

Enter value for quot: '
old 119:       <xsl:when test="contains($s,''"'')">
new 119:       <xsl:when test="contains($s,''';'')">

But what should I enter here?
Also I got an error creating object types 
T_NAME_VALUE_PAIR

PLS-00103: Encountered the symbol "CREATE" 

I'm running on DB 10.2.0.4 & APEX 3.2.1

Any hint is welcome.
Regards
Bernhard

Original comment by bernhard...@web.de on 29 Apr 2010 at 2:24

[GoogleCodeExporter]

@Bernhard:

Add the following at the beginning of the install.sql script:

set scan off;

This will disable sqlplus prompting for values when it sees quotation marks. 
(This 
small fix will be included in the next release of the integration kit.)

Not sure about the other error, the "create type" statement should work as long 
as 
the other similar statements worked.

Original comment by thehunge...@gmail.com on 4 May 2010 at 2:27

[GoogleCodeExporter]

I was able to install and after changing in the demo the table from emp2 to emp 
it
seems to work.
But I'm still getting errors.
In the package jqgrid_pkg.pkb the variable p_json is not set, therefor I get 
below
error message:
[Break on this error] var rs = eval (());\n
Trying to add a new row results in:
{"ROWSET": [{"ROW__ID":"","ENAME":"","JOB":"","HIREDATE":""}],
"STATUS__MESSAGE":"ORA-01400: cannot insert NULL into ("DNA"."EMP"."EMPNO")"}

Hope you can help again ;-)

Regards
Bernhard

Original comment by bernhard...@web.de on 7 May 2010 at 2:37

[GoogleCodeExporter]

@Bernhard:

I am not sure what you mean by "the variable p_json is not set", but I have 
seen that 
IE will choke on an empty dataset (var rs = eval (());). This will be addressed 
in 
the next release of the JQGrid Integration Kit.

In the meantime, make sure that your query (or ref cursor) is actually 
returning 
rows. Also, and this is not documented (yet), you will need to include a column 
in 
your query called "row__id" that will serve as the row id on the client. This 
is 
usually the same as your primary key, but will need to have this specific name.

For example, "select empno as row__id, empno, ename, job, hiredate from emp".

The error you are getting on insert is because EMPNO is a non-null column in 
the EMP 
table, so you will need to supply a value for EMPNO. I recommend either having 
a 
trigger on the table that automatically populates the primary key, or create a 
function that performs the insert and returns the new primary key value (and 
then put 
the name of this function in the ROW_CREATE_API column of the JQGRID 
configuration 
table.

Original comment by thehunge...@gmail.com on 7 May 2010 at 6:37

[GoogleCodeExporter]

Original comment by thehunge...@gmail.com on 22 May 2012 at 8:59

• Changed state: Done