When I run through the 'tutorial-37-how-to-build-a-calendar-part-ii' tutorial and I hava build the calendar_pkg package, I have to make a new Action 'clickCalendar', - but I am getting the same Error again and again. 'calendar_pkg.clickCalendar' - Method is Invalid. Is it possible to go through the Tutorial with a Trial license?

asked 05 Aug '14, 09:00

Michael%20Olsen's gravatar image

Michael Olsen
112
accept rate: 0%


Hi Michael,

The trial license is a full license for 30 days. So yes, you should be able to complete the calendar tutorial.

I can think of two reasons why you might be getting this error:

1) What is the datasource schema of your application? The datasource schema of your application should be the schema where the calendar_pkg is. You can edit the datasource schema of your application from the Edit Current Application icon right next to the application selection combobox in the IDE.


alt text


alt text

2) Did you put the clickCalendar procedure to the package spec? :-)

Kind Regards,
Yalim

link

answered 05 Aug '14, 09:09

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5
accept rate: 15%

edited 05 Aug '14, 09:13

Hi Yalim. Yes, the calendar_pkg is in the same datasource schema, and with the clickCalendar procedure inside - both SPEC and BODY. I created the application with the name Calendar and in HR schema, and this is where the calendar_pkg package also is. And if is was something with access right, I gave the Formspider schema execute right to the package, but still the same error.

link

answered 05 Aug '14, 09:14

Michael%20Olsen's gravatar image

Michael Olsen
112
accept rate: 0%

Could you please click OK even if it says that the method is invalid? If you click OK, Formspider will show you a dialog with the error message. Maybe that can help us.

(05 Aug '14, 09:17) Yalim Gerger ♦♦

Did you edit the datasource schema value in the run configuration screen? There is a button in the toolbar to access this screen. If you change the datasource schema in the run configuration that would also cause this problem.

(05 Aug '14, 09:23) Yalim Gerger ♦♦

When I click OK, I get this Error: ORA-06508: PL/SQL: could not find program unit being called

And this is where the strange part is, because I am able to call the procedure manually, from within the HR schema.

link

answered 05 Aug '14, 09:24

Michael%20Olsen's gravatar image

Michael Olsen
112
accept rate: 0%

This is odd. Do you have TeamViewer? If so, could you email us the information to remotely connect to you computer?

(05 Aug '14, 09:28) Yalim Gerger ♦♦

Hi Yalim. Yes I have TeamViewer, but we have to wait until tomorrow, because I am on my way how within the next 15 minuts. Do you have the time tomorrow to assist me?

Thanks in advance Michael

link

answered 05 Aug '14, 09:43

Michael%20Olsen's gravatar image

Michael Olsen
112
accept rate: 0%

Hi Michael,

Send us an email at contact@theformspider.com tomorrow and we'll figure it out.

Kind Regards,
Yalim

(05 Aug '14, 09:52) Yalim Gerger ♦♦

Hi Michael,

We thought of one more thing that might cause this issue. Do you see a package body named BDF_SCRIPTEXECUTER in your datasource schema?

This package and its body is critical for Formspider to function properly and if the package body is missing while the spec exists, you might get this error.

If you don't see the body but the spec is there, simply drop the spec as well and attempt to save your action. Formspider will recreate the package spec and its body during the save.

Kind Regards,
Yalim

(06 Aug '14, 06:40) Yalim Gerger ♦♦

Hi Yalim.

Thank you, now everything works fine :-) There was only the SPEC of the BDF_SCRIPTEXECUTER package, and when I drop the package, and rerun the calendar application it was created again. I got the same error later in the tutorial, and just by doing 'drop package' everything works fine again. Is it possible to get the days in danish, - like Monday is Mandag, and day,week,month is dag, uge, måned? Thanks in advance Michael

link

answered 06 Aug '14, 08:20

Michael%20Olsen's gravatar image

Michael Olsen
112
accept rate: 0%

Hi Michael,

Was the package body of BDF_SCRIPTEXECUTER missing again? This should never happen. Maybe somebody is dropping the package body?

For calendar days, we need to define the days in Danish. For now the calender component only support English and Turkish.

Build your application for now. If the time comes to go to production, you can tell us the days and months in Danish (or we can just look them up :-)) and we'll add them to the Calender's translation. No big deal.

Kind Regards,
Yalim

(06 Aug '14, 08:26) Yalim Gerger ♦♦

Hi Yalim No, the BODY wasn't missing, but I got the same error when I created a new Action, and when i drop the package, and rerun the application, the Actions got the 'Referenced by' Object Type, Object Name and Event Type, so now it's look perfect. And OK with the translation, if we are able to get the 'Label' in danish, it would be perfect, - and I'll get back to this later.

Thank you for your help, now I'll try the SRDEMO application :-)

/Michael

link

answered 06 Aug '14, 08:53

Michael%20Olsen's gravatar image

Michael Olsen
112
accept rate: 0%

Hi Michael,

Great. While you are trying the SRDEMO application, please note that the security implementation in Formspider applications is now much more simpler. We recently introduced a security repository feature but didn't have the time to update the SRDEMO app.

You can read more about the Formspider Security Repository at this URL: http://theformspider.com/learningcenter/using-formspider-security-repository/

Kind Regards, Yalim

(06 Aug '14, 09:15) Yalim Gerger ♦♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×6

Asked: 05 Aug '14, 09:00

Seen: 1,196 times

Last updated: 06 Aug '14, 09:15


© Copyright Gerger 2017