Question
SINARMASMSIGLIFE
ID
Last activity: 21 Mar 2017 4:53 EDT
Connect SQL using property statement
hi,
I have a problem with activity which calling RDB-Open using statement query by property when the contents of the property , i'm took from DB.
for example , value the propery is SELECT GREATEST(75, 5 * $P{AX} * $P{AZ} / 100 * $P{CC}) ABZA FROM DUAL , and then i'm passing into RDB - OPEN that property.
anyone can help me :)
thanks
Pegasystems Inc.
US
Hello,
As per the above query it looks like you are trying to use the property of a class in the RDB-Open. If so kindly refer the below article to achieve your requirement.
Regards,
Mahesh
Accepted Solution
Pegasystems Inc.
IN
Refer below two URL's for getting inputs on your use case.
SINARMASMSIGLIFE
ID
hi,
i get an error when i'm running activity?
There was a problem getting a list: code: 972 SQLState: 42000 Message: ORA-00972: identifier is too long
and , what is the best pratice for using ACTIVITY in class(work or data class) ? I've tried it several times but still not success
Pegasystems Inc.
IN
ORA-00972 is thrown when attempting to access a table that has a large column length.
Furthermore, ORA-00972 can be caused by column, alias, or table names which are too long. Could you please verify this is the case?
Oracle identifiers are not allowed to exceed 30 characters in length. See the Oracle SQL Language Reference.
Also,refer this link on activity https://community.pega.com/introduction-activities/introduction-activities
SINARMASMSIGLIFE
ID
hi othos,
thanks for your reference, I want to ask you something.
in RDB , i use
begin
execute immediate {.propB} into {.propA out};
end;
propB is a property of tempPage from AA-Data-BB (page & class) , then where should propA to be placed? in tempPage or where ?
thanks
SINARMASMSIGLIFE
ID
i want to ask a question that has been posted
in RDB , i use
begin
execute immediate {.propB} into {.propA out};
end;
propB is a property of tempPage from AA-Data-BB (page & class) , then where should propA to be placed? in tempPage or where ?
thanks
SINARMASMSIGLIFE
ID
I've found the solution.
but I use the activities in class work and I still don't understand why this doesn't run on the data class .
thanks