Hi all,
I have been trying to run wimpy point and I get a problem with one of
the xql files.
This is the error displayed
""Database operation "0or1row" failed (exception NSDB, "Query was not
a
statement returning rows.")""
The problem occurs at pres_title(variable- code given below), when I
look at my wp_presentation__new, it is all defined there. I possibly
do not know what to do here. I have now made audience and background
an alias, before they were simply declared as varchar, however I
beleive the problem occurs before that at pres_title as mentioned
earlier.
It would be much appreciated if someone could help me out here.
This is the Code that applies to the XQL file
select wp_presentation__new(
now(),
:user_id,
:creation_ip,
:pres_title,
:page_signature,
:copyright_notice,
:style,
:public_p,
:show_modified_p,
:audience,
:background
);
This is the code that applies to wp_presentation__new
create function wp_presentation__new (
timestamp,
integer,
varchar(400),
varchar(400),
varchar(400),
varchar(400),
integer,
boolean,
boolean,
varchar(400),
varchar(400)
)
returns integer as'
declare
creation_date alias for $1;
creation_user alias for $2;
creation_ip alias for $3;
pres_title alias for $4;
page_signature alias for $5;
copyright_notice alias for $6;
style alias for $7;
public_p alias for $8;
shaow_modified_p alias for $9;
audience alias for $10;
background alias for $11;
v_audience_item_id cr_items.item_id%TYPE;
v_background_item_id cr_items.item_id%TYPE;
v_revision_id cr_revisions.revision_id%TYPE;
v_audience_revision_id cr_revisions.revision_id%TYPE;
v_background_revision_id cr_revisions.revision_id%TYPE;
v_max_id integer;
v_name cr_wp_presentations.pres_title%TYPE;
begin
select coalesce(max(item_id),0) into v_max_id
from cr_items
where content_type = ''cr_wp_presentation''
and name like new__pres_title || ''%'';
v_name := new__pres_title || ''_'' || v_max_id;
..... cont
