›
Welcome to the SRP Forum! Please refer to the SRP Forum FAQ post if you have any questions regarding how the forum works.

SELECT_INTO has not been dimensioned or declared for use as a function or subroutine.

walterwalter
in OpenInsight


Function WS_EXPORT_PEOPLE_TABLE()

stmt = "LIST PEOPLE"
results = Select_Into( stmt, "JSON" )

Return 0

I have the above code in a stored procedure, and when I try to run it via System Editor, I get the error:
"B105: SELECT_INTO has not been dimensioned or declared for use as a function or subroutine."

I get the same error for a number of other functions.

I'm an experienced developer, but OpenInsight is something totally new to me.

I'm did not set up the OI development environment in which these errors occurred, but it is almost as if there are DLLs missing or something is misconfigured.

Does anyone have any idea why this is happening?

Comments

  • MattCrozierMattCrozier
    You need to use Declare statements for any external functions or subroutines. Click the link for details and examples.
  • BarryStevensBarryStevens
    edited July 18
    I would also suggest you compile first then execute so you do not get confused between what are compile errors and runtime errors.
  • walterwalter
    Thank you. I was missing the Declare statements. My issue has been resolved!
Sign In or Register to comment.